Home » RDBMS Server » Security » A question about ALTER User statement (9.2.0.8)
A question about ALTER User statement [message #284272] Thu, 29 November 2007 05:04 Go to next message
orausern
Messages: 826
Registered: December 2005
Senior Member
Hi,

For one of the user -user1, we have a user creation ddl , that contains the following line:

ALTER USER user1 DEFAULT ROLE ALL;

Can you convey what does it mean? - for example does it mean that this user will have DBA privileges? This ddl is generated by Toad.

Thanks,
Nirav
Re: A question about ALTER User statement [message #284304 is a reply to message #284272] Thu, 29 November 2007 06:02 Go to previous message
orausern
Messages: 826
Registered: December 2005
Senior Member
I got the clarification...this statement only means that all roles granted to user will be enabled at the time of his logon...
Previous Topic: auditing problem
Next Topic: getover the lock on the table
Goto Forum:
  


Current Time: Fri Mar 29 10:13:55 CDT 2024