OraFAQ Forum: Security » Kill Session privileges

Home » RDBMS Server » Security » Kill Session privileges

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Kill Session privileges [message #243155]

Wed, 06 June 2007 04:45

tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi

Senior Member

I create one user having the privileges of create session

kindly suggest what privileges is required to this user to kill a session. This user should have privileges of kill session only
he should n't do any activity except create session & kill session.

Regards

Tarun Mittal

Report message to a moderator

Re: Kill Session privileges [message #243162 is a reply to message #243155]

Wed, 06 June 2007 05:11

Michel Cadot
Messages: 68774
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

The privilege is ALTER SYSTEM but if you only want to allow him to kill session, you have to create a procedure to do this and grant him the privilege to execute it.

Regards
Michel

Report message to a moderator