Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2004
    Posts
    26

    Unanswered: kill a user session

    i want a startup triger to do the following:
    whenever user XX logs in
    I want to kill(disconnect) his session

    -i don't wan't to lock his account
    -i don't want to expire his password
    -......

    just kill his session

    thanx in advance

  2. #2
    Join Date
    Feb 2007
    Location
    Bratislava, Slovakia
    Posts
    85
    why???
    you can revoke grant create session privilege
    Beer contains just a small amount of vitamines - that's why it's necessary to drink lot of it.

  3. #3
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >just kill his session
    Assuming you have DBA privs to this database, you don't need anyone's permission. Just proceed with implementing the LOGON trigger.
    Just out of curiosity what is OS name & version; what Oracle DB version to 4 decimal places.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  4. #4
    Join Date
    Jul 2004
    Posts
    26
    but how can i kill his session

  5. #5
    Join Date
    Feb 2007
    Location
    Bratislava, Slovakia
    Posts
    85
    via userenv you can find out audsid of session in question.
    http://download-east.oracle.com/docs...htm#sthref2469
    kill session statement is here
    http://download-east.oracle.com/docs...htm#sthref4630
    use execute immediate statement
    http://download-east.oracle.com/docs...htm#sthref1559

    and test, test, test... when i can recommend, revoke create session privilege rather.
    Beer contains just a small amount of vitamines - that's why it's necessary to drink lot of it.

Posting Permissions

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