Database Security Checklist V5R1 December 2002 Field Security Operations Appendix C Audit Statement Shortcuts Defense Information Systems Agency UNCLASSIFIED Appendix C 1 V5R1 December 2002 APPENDIX C AUDIT STATEMENT SHORTCUTS Audit ShortcutIndividual Audit Statements CLUSTERSCREATE CLUSTER CREATE ANY CLUSTER ALTER ANY CLUSTER DROP ANY CLUSTER CONTEXTSCREATE ANY CONTEXT DROP ANY CONTEXT DATABASEALTER ANY DATABASE ALTER SYSTEM AUDIT SYSTEM DATABASE LINKSCREATE DATABASE LINK CREATE PULIC DATABASE LINK DROP PUBLIC DATABASE LINK DIMENSIONSCREATE DIMENSION CREATE ANY DIMENSION ALER ANY DIMENSION DROP ANY DIMENSION DIRECTORIESCREATE ANY DIRECTORY DROP ANY DIRECTORY INDEXTYPESCREATE INDEXTYPE CREATE ANY INDEXTYPE DROP ANY INDEXTYPE EXEUTE ANY INDEXTYPE INDEXESCREATE INDEXTYPE CREATE ANY INDEX ALTER ANY INDEX DROP ANY INDEX QUERY REWRITE GLOBAL QUERY REWRITE LIBRARIESCREATE LIBRARY CREATE ANY LIBRARY DROP LIBRARY DROP ANY LIBRARY Database Security Checklist V5R1 December 2002 Field Security Operations Appendix C Audit Statement Shortcuts Defense Information Systems Agency UNCLASSIFIED Appendix C 2 V5R1 December 2002 Audit ShortcutIndividual Audit Statements MATERIALIZED VIEWS CREATE MATERIALIZED VIEW CREATE ANY MATERIALIZED VIEW ALTER ANY MATERIALIZED VIEW DROP ANY MATERIALIZED VIEW QUERY REWRITE GLOBAL QUERY REWRITE OPERATORSCREATE OPERATOR CREATE ANY OPERATOR EXECUTE ANY OPERATOR DROP ANY OPERATOR OUTLINESCREATE ANY OUTLINE ALTER ANY OUTLINE DROP ANY OUTLINE PROCEDURESCREATE PROCEDURE CREATE ANY PROCEDURE ALTER ANY PROCEDURE DROP ANY PROCEDURE EXECUTE ANY PROCEDURE PROFILESCREATE PROFILE ALTER PROFILE DROP PROFILE ROLESCREATE ROLE ALTER ANY ROLE DROP ANY ROLE GRANT ANY ROLE ROLLBACK SEGMENTS CREATE ROLLBACK SEGMENT ALTER ROLLBACK SEGMENT DROP ROLLBACK SEGMENT SEQUENCESCREATE SEQUENCE CREATE ANY SEQUENCE ALTER ANY SEQUENCE DROP ANY SEQUENCE SELECT ANY SEQUENCE Database Security Checklist V5R1 December 2002 Field Security Operations Appendix C Audit Statement Shortcuts Defense Information Systems Agency UNCLASSIFIED Appendix C 3 V5R1 December 2002 Audit ShortcutIndividual Audit Statements SESSIONSCREATE SESSION ALTER RESOURCE COST ALTER SESSION RESTRICTED SESSION SNAPSHOTS SAME AS MATERIALIZED VIEWS CREATE SNAPSHOT CREATE ANY SNAPSHOT ALER ANY SNAPSHOT DROP ANY SNAPSHOT GLOBAL QUERY REWRITE QUERY REWRITE SYNONYMSCREATE SYNONYM CREATE ANY SYNONYM DROP ANY SYNONYM DROP PUBLIC SYNONYM TABLESCREATE ANY TABLE ALTER ANY TABLE BACKUP ANY TABLE DELETE ANY TABLE DROP ANY TABLE INSERT ANY TABLE LOCK ANY TABLE UPATE ANY TABLE SELECT ANY TABLE TABLESPACESCREATE TABLESPACE ALTER TABLESPACE DROP TABLESPACE MANAGE TABLESPACE UNLIMITED TABLESPACE TRIGGERSCREATE TRIGGER CREATE ANY TRIGGER ALTER ANY TRIGGER DROP ANY TRIGGER ADMINISTER DATABASE TRIGGER Database Security Checklist V5R1 December 2002 Field Security Operations Appendix C Audit Statement Shortcuts Defense Information Systems Agency UNCLASSIFIED Appendix C 4 V5R1 December 2002 Audit ShortcutIndividual Audit Statements TYPESCREATE TYPE CREATE ANY TYPE ALTER ANY TYPE DROP ANY TYPE EXECUTE ANY TYPE USERSCREATE USER ALTER USER BECOME USER DROP USER VIEWSCR