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>
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