Printable View
Don't laugh - we cannot change our schema password for some time due to application reasons.
If I have my current SID and SESSION# in an ON LOGON trigger, how do I kill my own session?
I will determine to-kill session OR not to-kill session by the OSUSER.
Thank you!
alter system kill session 'sid,serial#';
where sid and serial# are enclosed by single quotation marks and come from v$session for the user session you want to kill. You can't kill your current session in this manner. You may want to go out to the system (you're on UNIX?) and kill the process.
if you are using on-logon trigger then you may not need to kill the session at all. Simply do not execute the default functionality trigger, depending upon your condition.
just do a raise in your trigger and you will be kicked out