STATEMENT level AUDIT options in a DATABASE

STATEMENT level AUDIT options in a DATABASE

 Enable AUDIT options for a USER in DB

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



AUDIT CONNECT, DBA, RESOURCE BY <Username> BY ACCESS;