RE: Letting users kill their own sessions

[Fink, Dan]

Title: RE: Re:RE: Re[2]: controlling CPU usage through Oracle

I prefer the Microsoft 3-fingered salute...

-----Original Message-----
From: Gogala, Mladen [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 29, 2002 2:44 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Letting users kill their own sessions

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-----
From: Boivin, Patrice J [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 29, 2002 4:19 PM
To: Multiple recipients of list ORACLE-L
Subject: Letting users kill their own sessions

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: [EMAIL PROTECTED]