Home » RDBMS Server » Security » Fine-Grained Audit issue (10.2.0.1)
Fine-Grained Audit issue [message #557101] Fri, 08 June 2012 20:43
andy huang
Messages: 498
Registered: July 2011
Senior Member
Dear all,
I have done a Fine-Grained Audit on table tb_log, then i select the table and delete the table,but the FGA_LOG$ do not store the sqltext,how can i know which is the select statement or delete statement?

BEGIN
  DBMS_FGA.ADD_POLICY(
   object_schema      => 'SCOTT',
   object_name        => 'TB_LOG',
   policy_name        => 'CHK_HR_TB_LOG',
   enable             =>  TRUE,
   statement_types    => 'INSERT, UPDATE, SELECT, DELETE',
   audit_trail        =>  DBMS_FGA.DB);
END;


select count(1) from tb_log;
delete from tb_log;


SQL> select  sessionid, oshst, sqltext from FGA_LOG$;

 SESSIONID OSHST                SQLTEXT
---------- -------------------- --------------------
       228 WORKGROUP\HXL
       228 WORKGROUP\HXL


Previous Topic: Regarding ORAPW utility
Next Topic: Oracle wallet with Instant Client
Goto Forum:
  


Current Time: Sat Nov 29 03:20:48 CST 2014

Total time taken to generate the page: 0.08189 seconds