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_FGA_AUDIT_TRAIL

DBA_FGA_AUDIT_TRAIL lists all audit records for fine-grained auditing.

Column Datatype NULL Description

SESSION_ID

NUMBER

NOT NULL

Session id of the query

TIMESTAMP

DATE

NOT NULL

Timestamp of the query

DB_USER

VARCHAR2(30)

Database username who executed the query

OS_USER

VARCHAR2(255)

Operating system username who executed the query

USERHOST

VARCHAR2(128)

Numeric instance ID for the Oracle instance from which the user is accessing the database. Used only in environments with distributed file systems and shared database files.

CLIENT_ID

VARCHAR2(64)

Client identifier in each Oracle session

EXT_NAME

VARCHAR2(4000)

External name

OBJECT_SCHEMA

VARCHAR2(30)

Owner of the table or view

OBJECT_NAME

VARCHAR2(128)

Name of the table or view

POLICY_NAME

VARCHAR2(30)

Name of the Fine-Grained Auditing Policy

SCN

NUMBER

System change number (SCN) of the query

SQL_TEXT

NVARCHAR2(2000)

SQL text of the query

SQL_BIND

VARCHAR2(4000)

Bind variable data of the query

COMMENT$TEXT

VARCHAR2(4000)

Comments