12.2.01 : Privileges to execute KILL SESSION in a PROCEDURE
Hello,
The user User1 must be able to execute a PROC_KILL_SESSION procedure that belongs to the TOOL schema.
This TOOL.PROC_KILL_SESSION procedure contains the following statement:
ALTER SYSTEM KILL SESSION ... IMMEDIATE;
What privs must be assigned to user USER1 in order to be able to execute the TOOL.PROC_KILL_SESSION procedure?
SQL> GRANT EXECUTE ON TOOL.PROC_KILL_SESSION TO USER1; ???
SQL> grant select on v_ $ session to USER1 is it necessary ???
Thank you.
GD.