| FG Audit Sql_text Issue [message #536815] |
Fri, 23 December 2011 03:34  |
ashokanjj
Messages: 6
Registered: December 2007
Location: India
|
Junior Member |
|
|
Hi,
We have 2 nos 10g database. In both DB I have enabled FG Audit in same table with same policy with audit_trail =>DBMS_FGA.DB+DBMS_FGA.EXTENDED.
In one of the DB the sql_text column of the dba_fga_audit_trail view contain the actual sql commnad issied by the user. example). delete from custmaster where cuscode='121001125' and sql_bind column is blank.
But in the other db, the sql_text column of the dba_fga_audit_trail view contain the actual sql commnad issied by the user with bind variable. example) delete from custmaster where cuscode=:"SYS_B_0" and the sql_bind collumn contain the actual value ie) #1(7):201001125 .
BOth the db has cursor_sharing parameter set to SIMILAR.
Please help me where I have made mistake.
By
Ashokan,
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
