I have created a procedure to capture long running session and want to kill those session from procedure itself.
Procedure is capturing the sessions but kill session alter command is not working from the procedure.
Getting below error.
- 00000 – “insufficient privileges”
*Cause: An attempt was made to perform a database operation without
the necessary privileges.
*Action: Ask your database administrator or designated security
administrator to grant you the necessary privileges
Please guide me how to resolve this error.