Mogens,
What a brilliant idea! I'll definitely add this to my
bag of tricks.
- Anita
- Mogens Nørgaard <mno_at_MiracleAS.dk> wrote:
> And then of course you have the wonderful 8i feature
> of logoff triggers. We use them to catch various
> session
> waits (v$session_Event) right before they log out.
>
> nlzanen1_at_EY.NL wrote:
>
> > Not sure if it was mentioned or not but I just
> came back from a few days of
> > and had to delete the hundreds of messages.
> >
> > LISTENER.LOG file can tell you who logged on when
> >
> > Jack
> >
> >
> > Rahul
> > <rahul_at_ratelin To:
> Multiple recipients of list ORACLE-L
> <ORACLE-L_at_fatcity.com>
> > do.co.id> cc:
> (bcc: Jack van Zanen/nlzanen1/External/MEY/NL)
> > Sent by: Subject:
> RE: Last Login
> > root_at_fatcity.c
> > om
> >
> >
> > 05-06-2001
> > 11:58
> > Please respond
> > to ORACLE-L
> >
> >
> >
> > one way is to turn on the auditing, and check the
> "logoff_time"
> >
> > > ----------
> > > From: Johnv[SMTP:jh_vandam_at_yahoo.com]
> > > Sent: Tuesday, June 05, 2001 9:55 AM
> > > To: LazyDBA.com Discussion
> > > Subject: Last Login
> > >
> > > Hi Guys/Gals
> > >
> > > Can anyone identify for me how I can tell the
> last
> > > time an user account was used ( time stamp)??
> > >
> > > Thanks
> > >
> > >
> __________________________________________________
> > > Do You Yahoo!?
> > > Get personalized email addresses from Yahoo!
> Mail - only $35
> > > a year! http://personal.mail.yahoo.com/
> > >
> > > --------
> > > Oracle documentation is here:
> > >
> http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> > > To unsubscribe: send a blank email to
> oracledba-unsubscribe_at_LAZYDBA.com
> > > To subscribe: send a blank email to
> oracledba-subscribe_at_LAZYDBA.com
> > > Visit the list archive:
> http://www.LAZYDBA.com/odbareadmail.pl
> > > Tell yer mates about http://www.farAwayJobs.com
> > > By using this list you agree to these
> > > terms:http://www.lazydba.com/legal.html
> > >
> > --
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > --
> > Author: Rahul
> > INET: rahul_at_ratelindo.co.id
> >
> > 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).
> >
> >
>
> > De informatie verzonden in dit e-mailbericht is
> vertrouwelijk en is
> > uitsluitend bestemd voor de geadresseerde.
> Openbaarmaking,
> > vermenigvuldiging, verspreiding en/of verstrekking
> van deze informatie aan
> > derden is, behoudens voorafgaande schriftelijke
> toestemming van Ernst &
> > Young, niet toegestaan. Ernst & Young staat niet
> in voor de juiste en
> > volledige overbrenging van de inhoud van een
> verzonden e-mailbericht, noch
> > voor tijdige ontvangst daarvan. Ernst & Young kan
> niet garanderen dat een
> > verzonden e-mailbericht vrij is van virussen, noch
> dat e-mailberichten
> > worden overgebracht zonder inbreuk of tussenkomst
> van onbevoegde derden.
> >
> > Indien bovenstaand e-mailbericht niet aan u is
> gericht, verzoeken wij u
> > vriendelijk doch dringend het e-mailbericht te
> retourneren aan de verzender
> > en het origineel en eventuele kopieën te
> verwijderen en te vernietigen.
> >
> > Ernst & Young hanteert bij de uitoefening van haar
> werkzaamheden algemene
> > voorwaarden, waarin een beperking van
> aansprakelijkheid is opgenomen. De
> > algemene voorwaarden worden u op verzoek kosteloos
> toegezonden.
> >
>
> > The information contained in this communication is
> confidential and is
> > intended solely for the use of the individual or
> entity to whom it is
> > addressed. You should not copy, disclose or
> distribute this communication
> > without the authority of Ernst & Young. Ernst &
> Young is neither liable for
> > the proper and complete transmission of the
> information contained in this
> > communication nor for any delay in its receipt.
> Ernst & Young does not
> > guarantee that the integrity of this communication
> has been maintained nor
> > that the communication is free of viruses,
> interceptions or interference.
> >
> > If you are not the intended recipient of this
> communication please return
> > the communication to the sender and delete and
> destroy all copies.
> >
> > In carrying out its engagements, Ernst & Young
> applies general terms and
> > conditions, which contain a clause that limits its
> liability. A copy of
> > these terms and conditions is available on request
> free of charge.
> >
>
> >
> > --
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > --
> > Author:
> > INET: nlzanen1_at_EY.NL
> >
> > 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).
>
> --
> Venlig hilsen
>
> Mogens Nørgaard
>
> Technical Director
> Miracle A/S, Denmark
> Web: http://MiracleAS.dk
> Mobile: +45 2527 7100
>
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Mogens =?iso-8859-1?Q?N=F8rgaard?=
> INET: mno_at_MiracleAS.dk
>
> 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).
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35
a year!
http://personal.mail.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: A. Bardeen
INET: abardeen1_at_yahoo.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).
Received on Tue Jun 05 2001 - 06:52:30 CDT