I'm trying to find the best way to allow an Oracle 8i and 9i (running in True64 Unix) SQL Plus user who is not a DBA to kill his/her own session(s). I don't want to give the user the alter system privilege, just the ability to kill sessions running with his/her user id. I know how to find session information like SQL text to help the user identify the session(s) to kill. I have created a procedure which will accept a session id and serial number, verify that the user calling the procedure is the owner of the session to be killed and that the session to be killed is not the one calling procedure itself. The procedure uses dynamic SQL to issue the alter system kill session request. Does anyone have a better way to let users kill only their own sessions?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!