Database Software

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!

Audit session and SYS.AUD$

cougarredMar 6 2012 — edited Mar 8 2012

I have a requirement to report all users who have not logged in to the database (we have straight database security) in 45 days to our security team.

I turned on audit session and I issued a query to look at AUD$ (userid and timestamp#) against DBA_USERS to provide this report. However, I've noticed that my TIMESTAMP# always contains NULL no matter what.

Any explanation for this?

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 5 2012

Added on Mar 6 2012

#database-security, #database-security-general

3 comments

650 views