Link to home
Start Free TrialLog in
Avatar of mohammadzahid
mohammadzahidFlag for Canada

asked on

How to add external users in Oracle 11g to a role?

Hi,

We have a list of users that are Windows authenticated in sqlplus, but I cannot figure out a way to add them to a role so that they can execute a procedure. What is the command to add an external user to a role?

Procedure name = sp_test123  

SQL> grant execute on sp_test123 to Roleabc   <Granting execute to a role>

Rolename = Roleabc  

User1 = OPS$ABC\U1  

User2 = OPS$ABC\U2  
Thanks
Avatar of Kanti Prasad
Kanti Prasad

Hi

Oracle Administration Assistant for Windows can create and grant local and external database roles to Windows domain users and global groups.
http://docs.oracle.com/cd/B28359_01/win.111/b32010/external.htm
Avatar of slightwv (䄆 Netminder)
Should be the same way you grant the role to any user:
grant Roleabc to OPS$ABC\U1 ;
ASKER CERTIFIED SOLUTION
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial