Home » RDBMS Server » Security » FG Audit Sql_text Issue (10.2.0.3)
FG Audit Sql_text Issue [message #536815] Fri, 23 December 2011 03:34 Go to next message
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,
Re: FG Audit Sql_text Issue [message #536818 is a reply to message #536815] Fri, 23 December 2011 03:48 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The mistake is to not use cursor_sharing EXACT.
This is the only value that should be used.

Regards
Michel
Re: FG Audit Sql_text Issue [message #536828 is a reply to message #536815] Fri, 23 December 2011 04:17 Go to previous message
ashokanjj
Messages: 6
Registered: December 2007
Location: India
Junior Member
Hi Michel ,

You are correct. Thank you for your quick reply.

Bye
Ashokan.

Previous Topic: auditing problem
Next Topic: Database link password
Goto Forum:
  


Current Time: Fri Mar 29 08:13:32 CDT 2024