RE: Letting users kill their own sessions

What if the user's name is not JOY?

-----Original Message-----

Sent: Thursday, August 29, 2002 3:30 PM
To: Multiple recipients of list ORACLE-L

KILL JOY!
-----Original Message-----

Sent: Thursday, August 29, 2002 3:44 PM
To: Multiple recipients of list ORACLE-L

Yes, the process is called "logging out" and I normally let them do that. Keeping them tied to their computers would be a cruel and unusual punishment,
against the company policy and probably illegal.

-----Original Message-----

Sent: Thursday, August 29, 2002 4:19 PM
To: Multiple recipients of list ORACLE-L

Does anyone have a dynamic script that would let users kill their own sessions?  

I found something in Metalink but the script doesn't appear to verify whether the PID and SID supplied belongs to the person executing the procedure... not ideal.  

Thanks.

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des systèmes 
Technology Services        | Services technologiques 
Informatics Branch         | Direction de l'informatique 
Maritimes Region, DFO      | Région des Maritimes, MPO 

E-Mail: boivinp_at_mar.dfo-mpo.gc.ca

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Fink, Dan
  INET: Dan.Fink_at_mdx.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).