Audit

From Oracle FAQ
Jump to: navigation, search

AUDIT is an Oracle SQL statement for auditing statements, privileges and objects.

To enable database auditing, set AUDIT_TRAIL in your initialization parameter file. Typical values are: TRUE, OS, DB, XML, etc.

Examples[edit]

Statement audits

AUDIT DELETE ANY TABLE; 
AUDIT CREATE ANY DIRECTORY;

Object audits:

AUDIT ALL ON hr.employees_seq; 
Glossary of Terms
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z #