RAISE_APPLICATION_ERROR(-20001,'Session has Expired or Invalid sid/serial Arguments Passed') IF v_user IN ('SCOTT') THEN -the list can be extendedĮXECUTE IMMEDIATE 'ALTER SYSTEM KILL SESSION ''' || p_sid || ',' || p_serial || '''' ![]() Suppose we want to give kill session access to the user SCOTT to kill its own session CREATE OR REPLACE PROCEDURE sys.kill_session(p_sid NUMBER, p_serial NUMBER) This way developer will be more independent and DBA will also get time to work on other priorities This bottleneck can be achieved by creating a procedure and then giving execute on that procedure to the user. We can give alter system privilege but it will other grants also which Oracle DBA don’t want. ![]() We dont have any privilege like alter system kill session which can be given to the user. ![]() They want the oracle kill own session privilege. Often developers ask how we can kill our own session as they dont want to wait for the DBA to respond and kill.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |