oracle_audit_tracing

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision		 Previous revision
oracle_audit_tracing [2020/02/11 09:12] – andonovjoracle_audit_tracing [2020/03/05 15:26] (current) – andonovj
Line 133: Line 133:
 2. populate table: 2. populate table:
  select * FROM dba_fga_audit_trail where policy_name = 'AUDIT_CH1469152';  select * FROM dba_fga_audit_trail where policy_name = 'AUDIT_CH1469152';
 +
 +
 3. drop policy 3. drop policy
 exec DBMS_FGA.DROP_POLICY (object_schema => 'LICA',object_name =>  'T_MEZZI',policy_name => 'AUDIT_CH1469152'); 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> </sxh>
  • oracle_audit_tracing.1581412357.txt.gz
  • Last modified: 2020/02/11 17:12
  • (external edit)