Not sure of your experience with pl/sql but how about this:
 
 
a stored procedure, takes 2 parms, serial and sid.
 
validation in the stored proc matches the logged in user against the username in v$session.
 
if the names match, dynamic sql(ddl) to do the alter command to kill the session.
 
I've done this in the past but its been about 7 years ago.
 
joe
 

Reply via email to