-
How do I allow a user permission to kill his own session?
He also will consider me creating a package to be able to do this.
Any help.
I know how to kill it myself.
Thanks,
Nirasha
-
[url]http://www.dbasupport.com/forums/showthread.php?threadid=5908[/url]
Thread starter might help you...
-
create a procedure
You can create a stored procedure for this. The user that creates the procedure should have ALTER SYSTEM privileges granted directly to them. Then you grant EXECUTE privileges on your procedure to the users you allow to kill sessions. There are a few considerations when building this procedure, like what if they have multiple sessions, etc.
I would also scan thru some of the sample scripts that can be found in tech books and online sites - maybe there's a canned procedure written already for this.
Good Luck!
Tim Hussar
Oracle DBA
Birmingham, AL
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|