Kill session without alter system privs ?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: Kill session without alter system privs ?

  1. #1
    Join Date
    Dec 2001
    Posts
    141

    Cool

    Hi everybody !
    Is there any way to kill one Oracle'session of a user, connecting with the same user, but without the ALTER SYSTEM privilege ?
    Thanks in advance for your answers ...

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    no

  3. #3
    Join Date
    Dec 2001
    Posts
    141
    Do you know if this feature is present on the 9i release ?

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    no

    whats the point?
    if this exists then everyone can kill any sessions, isnt this crazy?

    if you want so everyone can kill session create a pl/sql procedure and grant executions to public

  5. #5
    Join Date
    Apr 2002
    Posts
    55
    htanga what a stupid question u have asked. ?


    VenDe ChukPeen Zuri

    Someone who quotes himself as a DBA and posts simple question in forums is a big idiot to me . I donot care what others think

  6. #6
    Join Date
    Dec 2001
    Posts
    141

    Wink

    The Pando's answer was helpful to me.
    He gave me good advice with the pl/sql procedure.
    This forum is a good way to share advices ...
    Thanks a lot to Pando.

  7. #7
    Join Date
    Jun 2002
    Location
    Denver
    Posts
    54
    May be, just may be following would work ( we did it long back(1997) and we did it for object privileges not for the system privilege, thatís why Iím not so sure ) :

    Create a role say SSN with a password.

    Assign necessary privileges say ALTER SESSION.

    Grant the role to the user.

    Alter user assigned defualt role giving every other role but leaving SSN. That way when they login, only default roles will be enabled.

    Then create a form (or a pl/sql procedure ) to allow them to kill their own session, you need to figure out which session to kill of course, since user will have additional session for the Form as well.

    In the pre-form trigger ( or in the beginning of the pl/sql) , enable role SSN using dbms_session.set_role.


  8. #8
    Join Date
    Dec 2001
    Posts
    141

    Smile

    Thanks you very much for your idea !

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