OraFAQ Forum: Security » I have two questions about authentication,can you help me?

Home » RDBMS Server » Security » I have two questions about authentication,can you help me?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

I have two questions about authentication,can you help me? [message #182870]

Tue, 18 July 2006 09:07

ldd500
Messages: 1
Registered: July 2006

Junior Member

I have two questions about authentication:
1.how can the clients transmit the identifier to Oracle before logon
2.After logon Oracle,how can I lock some roles of the user instead of revoking the roles?

Report message to a moderator

Re: I have two questions about authentication,can you help me? [message #186154 is a reply to message #182870]

Sun, 06 August 2006 10:19

Frank Naude
Messages: 4596
Registered: April 1998

Senior Member

1. You cannot.

2. You cannot lock roles. However, you can enable and disable them for a session. Example:

Code: [Select all] [Show/ hide]

SET ROLE manager IDENTIFIED BY oracle;

Report message to a moderator

Previous Topic:	OLS does not appear to work for PROXY connections
Next Topic:	Auditing SELECT statement with bind variables

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 16 23:42:47 CDT 2025