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
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
Last Comment
slightwv (䄆 Netminder)
Should be the same way you grant the role to any user:
grant Roleabc to OPS$ABC\U1 ;
grant Roleabc to OPS$ABC\U1 ;
ASKER CERTIFIED SOLUTION
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.
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