Cancelling User sessions

We have a problem at the moment were sessions are left hanging and causing other sessions to lock out. Because we don't have the privileges to kill sessions we currently have to contact the DBAs to do this for us, which obviously takes too much time.

Is it possible to create a procedure that will allow a user to cancel sessions with the same user id as the user executing the command. This will allow us to cancel our own sessions without causing a security breach.

I think I know how to code it but could someone confirm the theory is OK. I'm assuming as long as the owner of the procedure has kill session privilege then users who have access to the procedure will be able to kill the sessions belonging to them. The procedure will check that the user id of the session to be canceled is the same as the user id of the user running the procedure before the session is killed.

Hope this make sense.

PS Any ideas why debugging VB and stopping the program causes sessions to be left open. Received on Wed Jun 30 1999 - 11:19:53 CDT