Skip to Main Content
Oracle in a Nutshell
book

Oracle in a Nutshell

by Rick Greenwald, David C. Kreines
December 2002
Intermediate to advanced content levelIntermediate to advanced
928 pages
85h 29m
English
O'Reilly Media, Inc.
Content preview from Oracle in a Nutshell

Audit trail

The following views provide information about the status of auditing and audit trails:

ALL_DEF_AUDIT_OPTS

Lists the default auditing options in effect for new objects.

AUDIT_ACTIONS

Lists the audit codes and descriptions.

*_AUDIT_EXISTS

Contains audit trail information generated by AUDIT EXISTS and AUDIT NOEXISTS.

*_AUDIT_OBJECT

Contains audit trail information for object auditing.

*_AUDIT_SESSION

Contains audit trail information for all connects and disconnects.

*_AUDIT_STATEMENT

Contains audit trail information for all audited statements.

*_AUDIT_TRAIL

Contains all audit trail information. The other _AUDIT_ views are subsets of this view.

*_OBJ_AUDIT_OPTS

Lists all object auditing options in effect.

*_PRIV_AUDIT_OPTS

Lists all system privilege auditing options in effect.

STMT_AUDIT_OPTION_MAP

Lists the valid SQL statements that can be specified for statement auditing.

*_STMT_AUDIT_OPTS

Lists all statement auditing options in effect.

SYSTEM_PRIVILEGE_MAP

Lists the valid system privileges that can be specified for system privilege auditing.

TABLE_PRIVILEGE_MAP

Lists the valid object audit options that can be specified for schema object auditing.

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle Internals

Oracle Internals

Donald K. Burleson
Oracle PL/SQL

Oracle PL/SQL

Lewis Cunningham
Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Rick Greenwald, Robert Stackowiak, Jonathan Stern

Publisher Resources

ISBN: 0596003366Errata Page