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 Trail for a specific user

user4529974Feb 1 2017 — edited Feb 1 2017

Hi ,

As stated on the topic , I am looking for a way for us to track on the activities of the specific user. May or may not have the SYSDBA or SYSOPER privilege.

For example , HR.

I would like to know what are the details of his login , what are the objects that are changed by him , what were their original values , SQL statements executed , what procedure/functions that were executed etc.

Could we set up such audit trail log in Oracle 11gR2 Standard/Enterprise?

Thanks

This post has been answered by 2810868 on Feb 1 2017

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 1 2017

Added on Feb 1 2017

#database-security, #database-security-general

3 comments

545 views