DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Allow a user to kill his session

Hybrid View

  1. #1
    Join Date
    Nov 2000
    Posts
    205
    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.

    Thanks,
    Nirasha

  2. #2
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    [url]http://www.dbasupport.com/forums/showthread.php?threadid=5908[/url]

    Thread starter might help you...

  3. #3
    Join Date
    Oct 2000
    Posts
    10

    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