Results 1 to 4 of 4

Thread: killing session

  1. #1
    Join Date
    Aug 2003
    Posts
    62

    Unanswered: killing session

    Which are the rights to assign to a user to give him possibility of killing other users session ?

  2. #2
    Join Date
    Mar 2002
    Location
    Ireland
    Posts
    181
    Hi,

    You need the 'alter system' priv to kill a session.

    Now, I would not suggest granting this to a user, instead:

    Create a procedure that finds the session ID,serial and then kills it.
    Then give execute on this procedure to the user.

    Hope this helps,
    Breen.

  3. #3
    Join Date
    Sep 2003
    Location
    The Netherlands
    Posts
    311
    Hi,

    the user has to have the alter system privileges granted directly.

    Hope this helps
    Edwin van Hattem
    OCP DBA / System analyst

  4. #4
    Join Date
    Mar 2002
    Location
    Ireland
    Posts
    181
    Cheers Edwin,

    Didn't realise that.

    Rgs,
    Breen.

Posting Permissions

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