Oracle PL/SQL for DBAs

Name

DBA_FGA_AUDIT_TRAIL

Synopsis

This view shows the FGA audit trail.

		Oracle Database version
Column name	Description	9i	10g
SESSION_ID	AUDIT SESSION identifier. This is a unique session ID number; it is not the same as the SID column from the V$SESSION view.	Yes	Yes
TIMESTAMP	Time of the trail entry.	Yes	Yes
DB_USER	Database user that issued this query recorded in the trail.	Yes	Yes
OS_USER	Operating system user.	Yes	Yes
USERHOST	Hostname of the user.	Yes	Yes
CLIENT_ID	Client identifier of the session, if defined.	Yes	Yes
ECONTEXT_ID	Only in Oracle Database 10g Release 2. If a context is defined, the context ID is shown here.	No	Yes (R2)
EXT_NAME	If the user is externally authenticated, the external name is shown here.	Yes	Yes
OBJECT_SCHEMA	Owner of the table referenced by the statement.	Yes	Yes
OBJECT_NAME	Name of the table.	Yes	Yes
POLICY_NAME	Name of the policy that triggered this entry.	Yes	Yes
SCN	System Control Number of the database when this audit trail entry was generated. Used for flashback queries.	Yes	Yes
SQL_TEXT	Text of the SQL statement issued by the user.	Yes	Yes
SQL_BIND	Bind variables and their values in the SQL statement.	Yes	Yes
COMMENT$TEXT	Additional information about the audit trails is recorded here, if available.	Yes	Yes
STATEMENT_TYPE	Indicates the type of statement (e.g., SELECT).	No	Yes
EXTENDED_TIMESTAMP	Extended timestamp of the audit entry. This is recorded in the TIMESTAMP datatype, ...