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!

How could I audit specified synonym object ?

teradata0802Nov 15 2013 — edited Nov 15 2013

We are making Oracle Insight Application which is running on Oracle 11gR2 on win2008R2.

One day , we had Oracle Insight Application login error.

We talked with OracleSupport and were told to make synonym which refer to OracleSafetyDB USER_LOCK table as temporary solution and login error were resolved.

We are now searching permanent solution.

How could I set audit setting so that if that synonym we made are used , those DDL or DML statements are recorded in audit log ?

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 13 2013

Added on Nov 15 2013

#general-database-discussions

1 comment

425 views