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