Re: Last userid access
- From: Rachel Carmichael <wisernet100@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 25 Jun 2004 06:02:58 -0700 (PDT)
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@xxxxxxxxx> 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@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
