Database Administration (MOSC)

MOSC Banner

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center