OraFAQ Forum: Security

Home » RDBMS Server » Security » user roles

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

user roles [message #64614]

Tue, 15 February 2005 10:16

Ashi
Messages: 4
Registered: February 2005

Junior Member

Can a user have more than one default role ?

Also, can I define list of all roles into ‘alter user <username> default role <role1,role2,role3> ?

Regards

Report message to a moderator

Re: user roles [message #64621 is a reply to message #64614]

Tue, 15 February 2005 20:39

Sreedhar Reddy
Messages: 55
Registered: January 2002

Member

Create to your roles
grnat object,system privileges to roles

grant role1,role2,role3 to <user name>

Report message to a moderator

Re: user roles [message #108817 is a reply to message #64614]

Fri, 18 February 2005 10:40

tinny
Messages: 4
Registered: February 2005

Junior Member

Yes. Syntax is:
Alter user default role all; ->to make all roles default.

Report message to a moderator

Previous Topic:	SYS password
Next Topic:	sql username and password

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jan 18 03:55:06 CST 2026