Skip Headers

Oracle9i Database Reference
Release 2 (9.2)

Part Number A96536-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page Go to next page
View PDF

DBA_OBJ_AUDIT_OPTS

DBA_OBJ_AUDIT_OPTS describes auditing options on all objects.

Related View

USER_OBJ_AUDIT_OPTS describes auditing options on all objects owned by the current user. This view does not display the OWNER column.

Column Datatype NULL Description

OWNER

VARCHAR2(30)

Owner of the object

OBJECT_NAME

VARCHAR2(30)

Name of the object

OBJECT_TYPE

VARCHAR2(9)

Type of the object

ALT

VARCHAR2(3)

Auditing ALTER WHENEVER SUCCESSFUL/UNSUCCESSFUL

AUD

VARCHAR2(3)

Auditing AUDIT WHENEVER SUCCESSFUL/UNSUCCESSFUL

COM

VARCHAR2(3)

Auditing COMMENT WHENEVER SUCCESSFUL/UNSUCCESSFUL

DEL

VARCHAR2(3)

Auditing DELETE WHENEVER SUCCESSFUL/UNSUCCESSFUL

GRA

VARCHAR2(3)

Auditing GRANT WHENEVER SUCCESSFUL/UNSUCCESSFUL

IND

VARCHAR2(3)

Auditing INDEX WHENEVER SUCCESSFUL/UNSUCCESSFUL

INS

VARCHAR2(3)

Auditing INSERT WHENEVER SUCCESSFUL/UNSUCCESSFUL

LOC

VARCHAR2(3)

Auditing LOCK WHENEVER SUCCESSFUL/UNSUCCESSFUL

REN

VARCHAR2(3)

Auditing RENAME WHENEVER SUCCESSFUL/UNSUCCESSFUL

SEL

VARCHAR2(3)

Auditing SELECT WHENEVER SUCCESSFUL/UNSUCCESSFUL

UPD

VARCHAR2(3)

Auditing UPDATE WHENEVER SUCCESSFUL/UNSUCCESSFUL

REF

VARCHAR2(3)

Auditing REFERENCE WHENEVER SUCCESSFUL/UNSUCCESSFUL (not used)

EXE

VARCHAR2(3)

Auditing EXECUTE WHENEVER SUCCESSFUL/UNSUCCESSFUL

REA

VARCHAR2(3)

Auditing READ WHENEVER SUCCESSFUL/UNSUCCESSFUL