10 Replies Latest reply: Oct 24, 2012 12:35 PM by marlborocat RSS

    how to turn off this audit?

    marlborocat
      I see lots of auditing records getting generated with action# 85, i looked up, it is truncate table.

      how can i turn it off?

      the following are the current auditing option from this database. which one is generating this action# 85.


      ====

      AUDIT ADMINISTER ANY SQL TUNING SET BY ACCESS ;
      AUDIT ADMINISTER DATABASE TRIGGER BY ACCESS ;
      AUDIT ADMINISTER SQL MANAGEMENT OBJECT BY ACCESS ;
      AUDIT ADMINISTER SQL TUNING SET BY ACCESS ;
      AUDIT ADVISOR BY ACCESS ;
      AUDIT ALTER ANY ASSEMBLY BY ACCESS ;
      AUDIT ALTER ANY CLUSTER BY ACCESS ;
      AUDIT ALTER ANY CUBE BY ACCESS ;
      AUDIT ALTER ANY CUBE DIMENSION BY ACCESS ;
      AUDIT ALTER ANY DIMENSION BY ACCESS ;
      AUDIT ALTER ANY EDITION BY ACCESS ;
      AUDIT ALTER ANY EVALUATION CONTEXT BY ACCESS ;
      AUDIT ALTER ANY INDEX BY ACCESS ;
      AUDIT ALTER ANY INDEXTYPE BY ACCESS ;
      AUDIT ALTER ANY LIBRARY BY ACCESS ;
      AUDIT ALTER ANY MATERIALIZED VIEW BY ACCESS ;
      AUDIT ALTER ANY MINING MODEL BY ACCESS ;
      AUDIT ALTER ANY OPERATOR BY ACCESS ;
      AUDIT ALTER ANY OUTLINE BY ACCESS ;
      AUDIT ALTER ANY PROCEDURE BY ACCESS ;
      AUDIT ALTER ANY ROLE BY ACCESS ;
      AUDIT ALTER ANY RULE BY ACCESS ;
      AUDIT ALTER ANY RULE SET BY ACCESS ;
      AUDIT ALTER ANY SEQUENCE BY ACCESS ;
      AUDIT ALTER ANY SQL PROFILE BY ACCESS ;
      AUDIT ALTER ANY TABLE BY ACCESS ;
      AUDIT ALTER ANY TRIGGER BY ACCESS ;
      AUDIT ALTER ANY TYPE BY ACCESS ;
      AUDIT ALTER DATABASE BY ACCESS ;
      AUDIT ALTER DATABASE LINK BY ACCESS ;
      AUDIT ALTER JAVA CLASS BY ACCESS ;
      AUDIT ALTER JAVA RESOURCE BY ACCESS ;
      AUDIT ALTER JAVA SOURCE BY ACCESS ;
      AUDIT ALTER MINING MODEL BY ACCESS ;
      AUDIT ALTER PROFILE BY ACCESS ;
      AUDIT ALTER PUBLIC DATABASE LINK BY ACCESS ;
      AUDIT ALTER RESOURCE COST BY ACCESS ;
      AUDIT ALTER ROLLBACK SEGMENT BY ACCESS ;
      AUDIT ALTER SEQUENCE BY ACCESS ;
      AUDIT ALTER SESSION BY ACCESS ;
      AUDIT ALTER SYSTEM BY ACCESS ;
      AUDIT ALTER TABLE BY ACCESS ;
      AUDIT ALTER TABLESPACE BY ACCESS ;
      AUDIT ALTER USER BY ACCESS ;
      AUDIT ANALYZE ANY BY ACCESS ;
      AUDIT AUDIT ANY BY ACCESS ;
      AUDIT AUDIT SYSTEM BY ACCESS ;
      AUDIT BACKUP ANY TABLE BY ACCESS ;
      AUDIT BECOME USER BY ACCESS ;
      AUDIT CHANGE NOTIFICATION BY ACCESS ;
      AUDIT CLUSTER BY ACCESS ;
      AUDIT COMMENT ANY MINING MODEL BY ACCESS ;
      AUDIT COMMENT ANY TABLE BY ACCESS ;
      AUDIT COMMENT EDITION BY ACCESS ;
      AUDIT COMMENT MINING MODEL BY ACCESS ;
      AUDIT COMMENT TABLE BY ACCESS ;
      AUDIT CONTEXT BY ACCESS ;
      AUDIT CREATE ANY ASSEMBLY BY ACCESS ;
      AUDIT CREATE ANY CLUSTER BY ACCESS ;
      AUDIT CREATE ANY CONTEXT BY ACCESS ;
      AUDIT CREATE ANY CUBE BY ACCESS ;
      AUDIT CREATE ANY CUBE BUILD PROCESS BY ACCESS ;
      AUDIT CREATE ANY CUBE DIMENSION BY ACCESS ;
      AUDIT CREATE ANY DIMENSION BY ACCESS ;
      AUDIT CREATE ANY DIRECTORY BY ACCESS ;
      AUDIT CREATE ANY EDITION BY ACCESS ;
      AUDIT CREATE ANY EVALUATION CONTEXT BY ACCESS ;
      AUDIT CREATE ANY INDEX BY ACCESS ;
      AUDIT CREATE ANY INDEXTYPE BY ACCESS ;
      AUDIT CREATE ANY JOB BY ACCESS ;
      AUDIT CREATE ANY LIBRARY BY ACCESS ;
      AUDIT CREATE ANY MATERIALIZED VIEW BY ACCESS ;
      AUDIT CREATE ANY MEASURE FOLDER BY ACCESS ;
      AUDIT CREATE ANY MINING MODEL BY ACCESS ;
      AUDIT CREATE ANY OPERATOR BY ACCESS ;
      AUDIT CREATE ANY OUTLINE BY ACCESS ;
      AUDIT CREATE ANY PROCEDURE BY ACCESS ;
      AUDIT CREATE ANY RULE BY ACCESS ;
      AUDIT CREATE ANY RULE SET BY ACCESS ;
      AUDIT CREATE ANY SEQUENCE BY ACCESS ;
      AUDIT CREATE ANY SQL PROFILE BY ACCESS ;
      AUDIT CREATE ANY SYNONYM BY ACCESS ;
      AUDIT CREATE ANY TABLE BY ACCESS ;
      AUDIT CREATE ANY TRIGGER BY ACCESS ;
      AUDIT CREATE ANY TYPE BY ACCESS ;
      AUDIT CREATE ANY VIEW BY ACCESS ;
      AUDIT CREATE ASSEMBLY BY ACCESS ;
      AUDIT CREATE CLUSTER BY ACCESS ;
      AUDIT CREATE CUBE BY ACCESS ;
      AUDIT CREATE CUBE BUILD PROCESS BY ACCESS ;
      AUDIT CREATE CUBE DIMENSION BY ACCESS ;
      AUDIT CREATE DATABASE LINK BY ACCESS ;
      AUDIT CREATE DIMENSION BY ACCESS ;
      AUDIT CREATE EVALUATION CONTEXT BY ACCESS ;
      AUDIT CREATE EXTERNAL JOB BY ACCESS ;
      AUDIT CREATE INDEXTYPE BY ACCESS ;
      AUDIT CREATE JAVA CLASS BY ACCESS ;
      AUDIT CREATE JAVA RESOURCE BY ACCESS ;
      AUDIT CREATE JAVA SOURCE BY ACCESS ;
      AUDIT CREATE JOB BY ACCESS ;
      AUDIT CREATE LIBRARY BY ACCESS ;
      AUDIT CREATE MATERIALIZED VIEW BY ACCESS ;
      AUDIT CREATE MEASURE FOLDER BY ACCESS ;
      AUDIT CREATE MINING MODEL BY ACCESS ;
      AUDIT CREATE OPERATOR BY ACCESS ;
      AUDIT CREATE PROCEDURE BY ACCESS ;
      AUDIT CREATE PROFILE BY ACCESS ;
      AUDIT CREATE PUBLIC DATABASE LINK BY ACCESS ;
      AUDIT CREATE PUBLIC SYNONYM BY ACCESS ;
      AUDIT CREATE ROLE BY ACCESS ;
      AUDIT CREATE ROLLBACK SEGMENT BY ACCESS ;
      AUDIT CREATE RULE BY ACCESS ;
      AUDIT CREATE RULE SET BY ACCESS ;
      AUDIT CREATE SEQUENCE BY ACCESS ;
      AUDIT CREATE SESSION BY ACCESS ;
      AUDIT CREATE SYNONYM BY ACCESS ;
      AUDIT CREATE TABLE BY ACCESS ;
      AUDIT CREATE TABLESPACE BY ACCESS ;
      AUDIT CREATE TRIGGER BY ACCESS ;
      AUDIT CREATE TYPE BY ACCESS ;
      AUDIT CREATE USER BY ACCESS ;
      AUDIT CREATE VIEW BY ACCESS ;
      AUDIT DATABASE LINK BY ACCESS ;
      AUDIT DEBUG ANY PROCEDURE BY ACCESS ;
      AUDIT DEBUG CONNECT SESSION BY ACCESS ;
      AUDIT DEBUG PROCEDURE BY ACCESS ;
      AUDIT DELETE ANY CUBE DIMENSION BY ACCESS ;
      AUDIT DELETE ANY MEASURE FOLDER BY ACCESS ;
      AUDIT DELETE ANY TABLE BY ACCESS ;
      AUDIT DEQUEUE ANY QUEUE BY ACCESS ;
      AUDIT DIMENSION BY ACCESS ;
      AUDIT DIRECTORY BY ACCESS ;
      AUDIT DROP ANY ASSEMBLY BY ACCESS ;
      AUDIT DROP ANY CLUSTER BY ACCESS ;
      AUDIT DROP ANY CONTEXT BY ACCESS ;
      AUDIT DROP ANY CUBE BY ACCESS ;
      AUDIT DROP ANY CUBE BUILD PROCESS BY ACCESS ;
      AUDIT DROP ANY CUBE DIMENSION BY ACCESS ;
      AUDIT DROP ANY DIMENSION BY ACCESS ;
      AUDIT DROP ANY DIRECTORY BY ACCESS ;
      AUDIT DROP ANY EDITION BY ACCESS ;
      AUDIT DROP ANY EVALUATION CONTEXT BY ACCESS ;
      AUDIT DROP ANY INDEX BY ACCESS ;
      AUDIT DROP ANY INDEXTYPE BY ACCESS ;
      AUDIT DROP ANY LIBRARY BY ACCESS ;
      AUDIT DROP ANY MATERIALIZED VIEW BY ACCESS ;
      AUDIT DROP ANY MEASURE FOLDER BY ACCESS ;
      AUDIT DROP ANY MINING MODEL BY ACCESS ;
      AUDIT DROP ANY OPERATOR BY ACCESS ;
      AUDIT DROP ANY OUTLINE BY ACCESS ;
      AUDIT DROP ANY PROCEDURE BY ACCESS ;
      AUDIT DROP ANY ROLE BY ACCESS ;
      AUDIT DROP ANY RULE BY ACCESS ;
      AUDIT DROP ANY RULE SET BY ACCESS ;
      AUDIT DROP ANY SEQUENCE BY ACCESS ;
      AUDIT DROP ANY SQL PROFILE BY ACCESS ;
      AUDIT DROP ANY SYNONYM BY ACCESS ;
      AUDIT DROP ANY TABLE BY ACCESS ;
      AUDIT DROP ANY TRIGGER BY ACCESS ;
      AUDIT DROP ANY TYPE BY ACCESS ;
      AUDIT DROP ANY VIEW BY ACCESS ;
      AUDIT DROP JAVA CLASS BY ACCESS ;
      AUDIT DROP JAVA RESOURCE BY ACCESS ;
      AUDIT DROP JAVA SOURCE BY ACCESS ;
      AUDIT DROP PROFILE BY ACCESS ;
      AUDIT DROP PUBLIC DATABASE LINK BY ACCESS ;
      AUDIT DROP PUBLIC SYNONYM BY ACCESS ;
      AUDIT DROP ROLLBACK SEGMENT BY ACCESS ;
      AUDIT DROP TABLESPACE BY ACCESS ;
      AUDIT DROP USER BY ACCESS ;
      AUDIT ENQUEUE ANY QUEUE BY ACCESS ;
      AUDIT EXECUTE ANY ASSEMBLY BY ACCESS ;
      AUDIT EXECUTE ANY CLASS BY ACCESS ;
      AUDIT EXECUTE ANY EVALUATION CONTEXT BY ACCESS ;
      AUDIT EXECUTE ANY INDEXTYPE BY ACCESS ;
      AUDIT EXECUTE ANY LIBRARY BY ACCESS ;
      AUDIT EXECUTE ANY OPERATOR BY ACCESS ;
      AUDIT EXECUTE ANY PROCEDURE BY ACCESS ;
      AUDIT EXECUTE ANY PROGRAM BY ACCESS ;
      AUDIT EXECUTE ANY RULE BY ACCESS ;
      AUDIT EXECUTE ANY RULE SET BY ACCESS ;
      AUDIT EXECUTE ANY TYPE BY ACCESS ;
      AUDIT EXECUTE ASSEMBLY BY SESSION ;
      AUDIT EXEMPT ACCESS POLICY BY ACCESS ;
      AUDIT EXEMPT IDENTITY POLICY BY ACCESS ;
      AUDIT EXPORT FULL DATABASE BY ACCESS ;
      AUDIT FLASHBACK ANY TABLE BY ACCESS ;
      AUDIT FLASHBACK ARCHIVE ADMINISTER BY ACCESS ;
      AUDIT FORCE ANY TRANSACTION BY ACCESS ;
      AUDIT FORCE TRANSACTION BY ACCESS ;
      AUDIT GLOBAL QUERY REWRITE BY ACCESS ;
      AUDIT GRANT ANY OBJECT PRIVILEGE BY ACCESS ;
      AUDIT GRANT ANY PRIVILEGE BY ACCESS ;
      AUDIT GRANT ANY ROLE BY ACCESS ;
      AUDIT GRANT DIRECTORY BY ACCESS ;
      AUDIT GRANT EDITION BY ACCESS ;
      AUDIT GRANT MINING MODEL BY ACCESS ;
      AUDIT GRANT PROCEDURE BY ACCESS ;
      AUDIT GRANT SEQUENCE BY ACCESS ;
      AUDIT GRANT TABLE BY ACCESS ;
      AUDIT GRANT TYPE BY ACCESS ;
      AUDIT IMPORT FULL DATABASE BY ACCESS ;
      AUDIT INDEX BY ACCESS ;
      AUDIT INSERT ANY CUBE DIMENSION BY ACCESS ;
      AUDIT INSERT ANY MEASURE FOLDER BY ACCESS ;
      AUDIT INSERT ANY TABLE BY ACCESS ;
      AUDIT LOCK ANY TABLE BY ACCESS ;
      AUDIT MANAGE ANY FILE GROUP BY ACCESS ;
      AUDIT MANAGE ANY QUEUE BY ACCESS ;
      AUDIT MANAGE FILE GROUP BY ACCESS ;
      AUDIT MANAGE SCHEDULER BY ACCESS ;
      AUDIT MANAGE TABLESPACE BY ACCESS ;
      AUDIT MATERIALIZED VIEW BY ACCESS ;
      AUDIT MERGE ANY VIEW BY ACCESS ;
      AUDIT MINING MODEL BY ACCESS ;
      AUDIT NOT EXISTS BY ACCESS ;
      AUDIT ON COMMIT REFRESH BY ACCESS ;
      AUDIT PROCEDURE BY ACCESS ;
      AUDIT PROFILE BY ACCESS ;
      AUDIT PUBLIC DATABASE LINK BY ACCESS ;
      AUDIT PUBLIC SYNONYM BY ACCESS ;
      AUDIT QUERY REWRITE BY ACCESS ;
      AUDIT READ ANY FILE GROUP BY ACCESS ;
      AUDIT RESTRICTED SESSION BY ACCESS ;
      AUDIT RESUMABLE BY ACCESS ;
      AUDIT ROLE BY ACCESS ;
      AUDIT ROLLBACK SEGMENT BY ACCESS ;
      AUDIT SELECT ANY CUBE BY ACCESS ;
      AUDIT SELECT ANY CUBE DIMENSION BY ACCESS ;
      AUDIT SELECT ANY MINING MODEL BY ACCESS ;
      AUDIT SELECT ANY SEQUENCE BY ACCESS ;
      AUDIT SELECT ANY TABLE BY ACCESS ;
      AUDIT SELECT ANY TRANSACTION BY ACCESS ;
      AUDIT SEQUENCE BY ACCESS ;
      AUDIT SYNONYM BY ACCESS ;
      AUDIT SYSDBA BY ACCESS ;
      AUDIT SYSOPER BY ACCESS ;
      AUDIT SYSTEM AUDIT BY ACCESS ;
      AUDIT SYSTEM GRANT BY ACCESS ;
      AUDIT TABLESPACE BY ACCESS ;
      AUDIT TRIGGER BY ACCESS ;
      AUDIT TYPE BY ACCESS ;
      AUDIT UNDER ANY TABLE BY ACCESS ;
      AUDIT UNDER ANY TYPE BY ACCESS ;
      AUDIT UNDER ANY VIEW BY ACCESS ;
      AUDIT UNLIMITED TABLESPACE BY ACCESS ;
      AUDIT UPDATE ANY CUBE BY ACCESS ;
      AUDIT UPDATE ANY CUBE BUILD PROCESS BY ACCESS ;
      AUDIT UPDATE ANY CUBE DIMENSION BY ACCESS ;
      AUDIT UPDATE ANY TABLE BY ACCESS ;
      AUDIT USER BY ACCESS ;
      AUDIT VIEW BY ACCESS ;

      ============