Home » RDBMS Server » Security » Fine-Grained Audit issue (
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?

   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);

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

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

---------- -------------------- --------------------
       228 WORKGROUP\HXL
       228 WORKGROUP\HXL

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

Current Time: Wed Aug 16 18:53:04 CDT 2017

Total time taken to generate the page: 0.11643 seconds