??: Forcing user to log off

From: Hatzistavrou Yiannis <jhatzis_at_cosmote.gr>
Date: Wed, 2 Aug 2000 09:44:26 +0200
Message-Id: <10576.113555@fatcity.com>

select '! kill -9 '||p.spid from v$process p,v$session s where p.addr=3Ds.paddr and s.username=3D'......';=20

copy and paste the result

-----=C1=F1=F7=E9=EA=FC =EC=DE=ED=F5=EC=E1-----

=C1=F0=FC: Jaime Perez [mailto:jaime_at_mail.laosb.org]
=C1=F0=EF=F3=F4=EF=EB=DE: =D4=E5=F4=DC=F1=F4=E7, 2 =
=C1=F5=E3=EF=FD=F3=F4=EF=F5 2000 7:15 =F0=EC
=D0=F1=EF=F2: Multiple recipients of list ORACLE-L
=C8=DD=EC=E1: Re: Forcing user to log off

Yes there is a guy.
Let me look at my books again.
Can you make sure if nobody has helped you to remind me again. I am in the middle of training and I can't see the book cause it is at = home.

-jaime

Original Message ----- To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Thursday, July 27, 2000 1:06 PM

>
> >From Oracle, how can you force a user to log off?
>
> This is Oracle 8.0.5/UNIX and I know I can kill the PID, but
> is there a way to do it from Oracle?
>
> -----
> Sent using MailStart.com ( http://MailStart.Com/welcome.html )
> The FREE way to access your mailbox via any web browser, anywhere!
>
> --
> Author:
> INET: cemail_at_sprintmail.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).
>

--=20
Author: Jaime Perez
INET: jaime_at_mail.laosb.org

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). Received on Wed Aug 02 2000 - 02:44:26 CDT