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?


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  
Avatar of Kanti Prasad
Kanti Prasad


Oracle Administration Assistant for Windows can create and grant local and external database roles to Windows domain users and global groups.
Avatar of slightwv (䄆 Netminder)
Should be the same way you grant the role to any user:
grant Roleabc to OPS$ABC\U1 ;
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

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