Skip to Main Content

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!

Simple way to find user activity

user8983130Jan 22 2014 — edited Jan 26 2014

Hi,

I got my audit_trail is set to DB , which means all the user activities is record to AUD$ table..right??

Now if i given a username to find out what he did on a given date, what is the simplest query to find his/her activities from AUD$ table????

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 23 2014
Added on Jan 22 2014
13 comments
18,307 views