on DBMS_FGA & DML Statements
ramarunOct 11 2010 — edited Oct 14 2010Hi ,
I was able to get on and configure FGA in my database and get my SQLs getting logged in DBA_FGA_AUDIT_TRAIL. However my requirement is to get the DML statements in the before triggers of the table.
When i execute a insert/update/delete statement on a table say i.e EMP. I would llike to see the statement executed in the before insert/update/delete triggers of the respective table. But even after configuring FGA i.e Audit Policy for EMP table i am unable to get any records getting inserted into DBA_FGA_AUDIT_TRAIL when i query this view in BEFORE Update Trigger of the table
How to get my DML statement or atleast the where clause of the DML statement in my before triggers. Please help in this regard.
I have gone through the links and documents given below but none of that speaks about my requirment.
Notes i have visited.
http://download.oracle.com/docs/cd/B19306_01/network.102/b14266/cfgaudit.htm#i1011302
Metalink Notes
10g: Fine Grained Auditing (Doc ID 266896.1)
How to use DBMS_FGA with a complex audit_condition (include/exclude multiple users) (Doc ID 832856.1)
Thanks in advance