Audit
From Oracle FAQ
⧼orafaq-jumptonavigation⧽⧼orafaq-jumptosearch⧽
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
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 | # |
