OraFAQ Forum: Security » A question about ALTER User statement

Home » RDBMS Server » Security » A question about ALTER User statement (9.2.0.8)

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

A question about ALTER User statement [message #284272]

Thu, 29 November 2007 05:04

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

Report message to a moderator

Re: A question about ALTER User statement [message #284304 is a reply to message #284272]

Thu, 29 November 2007 06:02

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...

Report message to a moderator

Previous Topic:	auditing problem
Next Topic:	getover the lock on the table

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 07 19:08:29 CDT 2026