Home » RDBMS Server » Security » user roles
user roles [message #64614] Tue, 15 February 2005 10:16 Go to next message
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
Re: user roles [message #64621 is a reply to message #64614] Tue, 15 February 2005 20:39 Go to previous messageGo to next message
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>
Re: user roles [message #108817 is a reply to message #64614] Fri, 18 February 2005 10:40 Go to previous message
tinny
Messages: 4
Registered: February 2005
Junior Member
Yes. Syntax is:
Alter user default role all; ->to make all roles default.
Previous Topic: SYS password
Next Topic: sql username and password
Goto Forum:
  


Current Time: Fri Mar 29 09:35:45 CDT 2024