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
-----------------------------------------------------------------
Received on Fri Jun 25 2004 - 07:59:50 CDT
