Rachel,
Thanks for the quick response. While searching around some
more I found an article by Donald Burleson that uses just
this method. I am actually reading it right now. This looks
like the way to go. Actually, his article also talks about
trapping logout information. This can then be used for
tracking peaks in usage, etc. as well.
Thanks again. I wasnt sure if I was overlooking something.
Larry
- Rachel Carmichael <wisernet100_at_yahoo.com> wrote:
> As far as I know, there is nothing within the database
> that will log
> last sign on. Rather than turn on auditing, what about a
> login trigger
> that records the userid and date in a table?
>
> You can collect more information that way -- machine they
> logged in
> from, program they used etc..
>
> Rachel
>
> --- Larry Hahn <lhahn_60_at_yahoo.com> wrote:
> > List,
> >
> > Is there somewhere that I can find out the last date
> that a
> > userid logged into a database? For auditing purposes,
> > management wants a list of the last time a user signed
> in
> > for each database.
> >
> > The only way I can think of off the top of my head
> would be
> > to set up auditing and track successful logins. Does
> anyone
> > know if this date is tucked away in some table
> somewhere?
> > This would be for both version 8.1.7 and 9.0.2.
> >
> > Thanks in advance....Larry
> >
> >
> >
> > =====
> >
> >
> >
> >
> >
> > __________________________________
> > Do you Yahoo!?
> > New and Improved Yahoo! Mail - 100MB free storage!
> > http://promotions.yahoo.com/new_mail
> >
>
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> >
>
> > To unsubscribe send email to:
> oracle-l-request_at_freelists.org
> > put 'unsubscribe' in the subject line.
> > --
> > Archives are at
> http://www.freelists.org/archives/oracle-l/
> > FAQ is at
> http://www.freelists.org/help/fom-serve/cache/1.html
> >
>
> >
>
>
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
>
> To unsubscribe send email to:
> oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at
> http://www.freelists.org/archives/oracle-l/
> FAQ is at
> http://www.freelists.org/help/fom-serve/cache/1.html
>
>
Do you Yahoo!?
Yahoo! Mail - 50x more storage than other providers!
http://promotions.yahoo.com/new_mail
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Fri Jun 25 2004 - 08:08:18 CDT
