Home » RDBMS Server » Security » I have two questions about authentication,can you help me?
I have two questions about authentication,can you help me? [message #182870] Tue, 18 July 2006 09:07 Go to next message
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?
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 Go to previous message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
1. You cannot.

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

SET ROLE manager IDENTIFIED BY oracle;
Previous Topic: OLS does not appear to work for PROXY connections
Next Topic: Auditing SELECT statement with bind variables
Goto Forum:
  


Current Time: Thu Dec 08 18:27:18 CST 2016

Total time taken to generate the page: 0.13135 seconds