DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2000
    How do I allow a user permission to kill his own session?

    He also will consider me creating a package to be able to do this.

    Any help.

    I know how to kill it myself.


  2. #2
    Join Date
    Feb 2000
    Washington DC

    Thread starter might help you...

  3. #3
    Join Date
    Oct 2000

    create a procedure

    You can create a stored procedure for this. The user that creates the procedure should have ALTER SYSTEM privileges granted directly to them. Then you grant EXECUTE privileges on your procedure to the users you allow to kill sessions. There are a few considerations when building this procedure, like what if they have multiple sessions, etc.

    I would also scan thru some of the sample scripts that can be found in tech books and online sites - maybe there's a canned procedure written already for this.

    Good Luck!

    Tim Hussar
    Oracle DBA
    Birmingham, AL

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width