Database Security Products (MOSC)

MOSC Banner

auditing dml on table with cursor_sharing

edited May 5, 2010 1:15AM in Database Security Products (MOSC) 5 commentsAnswered
 I want to audit deletions on a table.  I set up a test table first and it worked fine.  The problem is I noticed the value used in the 'where condition' does not show up because parameter cursor_sharing is set to similiar.

Knowing what value was used is important.  Do I have any recourse here (other than turning cursor_sharing off)?

select sql_text from dba_common_audit_trail where object_name = 'DELETEME';

delete from deleteme where col1 = :"SYS_B_0"

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center