Differences

This shows you the differences between two versions of the page.

--- oracle_audit_tracing [2019/08/09 17:01] – [Tracing] andonovj
+++ oracle_audit_tracing [2020/03/05 15:26] (current) – andonovj
@@ Line 117: / Line 117: @@
 SQL> EXEC DBMS_MONITOR.client_id_trace_enable(client_id=>'tim_hall', waits=>TRUE, binds=>FALSE);
 SQL> EXEC DBMS_MONITOR.client_id_trace_disable(client_id=>'tim_hall');
+</sxh>
+====Specific Object (e.g. Table)====
+<sxh bash>
+. enable policy
+begin
+    dbms_fga.add_policy (
+      object_schema        => 'LICA',
+      object_name          => 'T_MEZZI',
+      policy_name          => 'AUDIT_CH1469152',
+       enable               =>  TRUE,
+      statement_types      => 'UPDATE,INSERT,DELETE');
+end;
+/
+. populate table:
+ select * FROM dba_fga_audit_trail where policy_name = 'AUDIT_CH1469152';
+. drop policy
+exec DBMS_FGA.DROP_POLICY (object_schema => 'LICA',object_name =>  'T_MEZZI',policy_name => 'AUDIT_CH1469152');
+</sxh>
+You can of course choose to export to CSV using the following syntax on SQL:
+<sxh bash>
+set embedded on
+set pagesize 0
+set colsep ';'
+set echo off
+set feedback off
+set linesize 32767
+set trimspool on
+set headsep off
+spool name.csv
 </sxh>