SQL & PL/SQL

Hi,

I received a message asking me whether our application makes use of a certain public synonym because
the application owner wants to drop that. This made me think about how to figure that out without checking
all the applications with oracle techniques.

I thought about triggers, but figured that they don't differentiate between the public synonym and the
table itself. So I thought about creating an intermediate view, and redirecting the public synonym to that
view which does nothing but a select * from table.
With that technique I can monitor updates,deletes and inserts but selects are still invisible to me.

Therefore audit came to my mind. I enabled auditing including capturing of the sql text and am now able
to see selects,inserts,updates and deletes. But auditing also doesn't differentiate between public synonyms
and their targets. I would need to review the stored sql together with the username to determine whether
the synonym or the table was used.

Is there an easier solution?