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>