May 17, 2007 #1 oradba101 MIS Feb 28, 2003 318 US Good morning, Is there anyway a user can have the ability to kill their own sessions? If it is possible how is this set up? Regards, William Chadbourne Oracle DBA
Good morning, Is there anyway a user can have the ability to kill their own sessions? If it is possible how is this set up? Regards, William Chadbourne Oracle DBA
May 17, 2007 #2 Dagon MIS Jan 30, 2002 2,301 GB It would be a useful feature, but I don't believe it is possible. You need DBA privilege to be able to issue the "alter system kill session" command. Upvote 0 Downvote
It would be a useful feature, but I don't believe it is possible. You need DBA privilege to be able to issue the "alter system kill session" command.
May 17, 2007 Thread starter #3 oradba101 MIS Feb 28, 2003 318 US Hi, Dagan I believe it can be accomplished with a PL/SQL procedure. However, you are probably right. Regards, William Chadbourne Oracle DBA Upvote 0 Downvote
Hi, Dagan I believe it can be accomplished with a PL/SQL procedure. However, you are probably right. Regards, William Chadbourne Oracle DBA