Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Retrieving all users and last successful login

729073Oct 20 2009 — edited Oct 20 2009

Hi. I"m trying to return a list of all users and thier last successful login to a particular database. Oracle version is 10.2.0.4 on RHEL 5.3. I am attempting to join to the sys.aud$ table or use the audit_trail views but I didn't know if there was something more obvious to do. We don't have Audit vault yet nor do we have actual logon triggers that write to an audit table - just have auditing turned on. audit_trail=db_extended.

I appreciate any help in advance.

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 17 2009

Added on Oct 20 2009

#audit, #general-database-discussions

2 comments

458 views