Kill session without alter system privs ?

[htanga]

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 ...

[pando]

no

[htanga]

Do you know if this feature is present on the 9i release ?

[pando]

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

[vendechukp]

htanga what a stupid question u have asked. ?

[htanga]

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.

[shibha]

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.

[htanga]

Thanks you very much for your idea !