Avatar of mohammadzahid
mohammadzahid
Flag 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
Oracle Database

Avatar of undefined
Last Comment
slightwv (䄆 Netminder)

8/22/2022 - Mon
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
slightwv (䄆 Netminder)

Should be the same way you grant the role to any user:
grant Roleabc to OPS$ABC\U1 ;
ASKER CERTIFIED SOLUTION
slightwv (䄆 Netminder)

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes