[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | CDB_COMMON_AUDIT_TRAIL |
|---|---|
| Object Type: | VIEW |
| Owner: | SYS |
| Subobject Name: | |
| Status: | VALID |
Combined Standard and Fine Grained audit trail entries in all containers
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| AUDIT_TYPE | VARCHAR2 | (22) | Audit trail type | |
| SESSION_ID | NUMBER | Numeric id for the Oracle session | ||
| PROXY_SESSIONID | NUMBER | Proxy session serial number, if enterprise user has logged through proxy mechanism | ||
| STATEMENTID | NUMBER | Numeric id for the statement run (a statement may cause multiple audit records) | ||
| ENTRYID | NUMBER | Numeric id for the audit trail entry in the session | ||
| EXTENDED_TIMESTAMP | TIMESTAMP(6) WITH TIME ZONE | (20) | Timestamp of the audited operation (Timestamp of the user's logon for entries created by AUDIT SESSION) in session's time zone | |
| GLOBAL_UID | VARCHAR2 | (32) | Global user identifier for the user, if the user had logged in as enterprise user | |
| DB_USER | VARCHAR2 | (128) | Database username of the user whose actions were audited | |
| CLIENT_ID | VARCHAR2 | (128) | Client identifier in the Oracle session | |
| ECONTEXT_ID | VARCHAR2 | (64) | Execution Context Identifier for each action | |
| EXT_NAME | VARCHAR2 | (4000) | User external name | |
| OS_USER | VARCHAR2 | (255) | Operating System logon user name of the user whose actions were audited | |
| USERHOST | VARCHAR2 | (128) | Client host machine name | |
| OS_PROCESS | VARCHAR2 | (16) | Operating System process identifier of the Oracle server process | |
| TERMINAL | VARCHAR2 | (255) | Identifier for the user's terminal | |
| INSTANCE_NUMBER | NUMBER | Instance number as specified in the initialization parameter file 'init.ora' | ||
| OBJECT_SCHEMA | VARCHAR2 | (128) | Owner of the audited object | |
| OBJECT_NAME | VARCHAR2 | (128) | Name of the object affected by the action | |
| POLICY_NAME | VARCHAR2 | (128) | Name of Fine Grained Auditing Policy | |
| NEW_OWNER | VARCHAR2 | (128) | Owner of the object named in the NEW_NAME column | |
| NEW_NAME | VARCHAR2 | (128) | New name of object after RENAME, or name of underlying object (e.g. CREATE INDEX owner.obj_name ON new_owner.new_name) | |
| ACTION | NUMBER | Numeric action type code | ||
| STATEMENT_TYPE | VARCHAR2 | (28) | Action type corresponding to the numeric code in ACTION | |
| AUDIT_OPTION | VARCHAR2 | (40) | Auditing option set with the standard audit statement | |
| TRANSACTIONID | RAW | (8) | Transaction identifier of the transaction in which the object is accessed or modified | |
| RETURNCODE | NUMBER | Oracle error code generated by the action. Zero if the action succeeded | ||
| SCN | NUMBER | SCN (System Change Number) of the query | ||
| COMMENT_TEXT | VARCHAR2 | (4000) | Text comment on the audit trail entry. Also indicates how the user was authenticated. The method can be one of the following: 1. "DATABASE" - authentication was done by password. 2. "NETWORK" - authentication was done by Net8 or the Advanced Networking Option. 3. "PROXY" - the client was authenticated by another user. The name of the proxy user follows the method type. | |
| SQL_BIND | NVARCHAR2 | (4000) | Bind variable data of the query | |
| SQL_TEXT | NVARCHAR2 | (4000) | SQL text of the query | |
| OBJ_PRIVILEGE | VARCHAR2 | (16) | Object privileges granted/revoked by a GRANT/REVOKE statement | |
| SYS_PRIVILEGE | VARCHAR2 | (40) | System privileges granted/revoked by a GRANT/REVOKE statement | |
| ADMIN_OPTION | VARCHAR2 | (1) | If role/sys_priv was granted WITH ADMIN OPTON, A/- | |
| OS_PRIVILEGE | VARCHAR2 | (7) | Operating Privilege (SYSDBA/SYSOPER) used in the session. If no privilege is used, it will be NONE | |
| GRANTEE | VARCHAR2 | (128) | The name of the grantee specified in a GRANT/REVOKE statement | |
| PRIV_USED | VARCHAR2 | (40) | System privilege used to perform the action | |
| SES_ACTIONS | VARCHAR2 | (19) | Session summary. A string of 12 characters, one for each action type, in thisorder: Alter, Audit, Comment, Delete, Grant, Index, Insert, Lock, Rename, Select, Update, Flashback. Values: "-" = None, "S" = Success, "F" = Failure, "B" = Both | |
| LOGOFF_TIME | DATE | |||
| LOGOFF_LREAD | NUMBER | |||
| LOGOFF_PREAD | NUMBER | |||
| LOGOFF_LWRITE | NUMBER | |||
| LOGOFF_DLOCK | VARCHAR2 | (40) | ||
| SESSION_CPU | NUMBER | |||
| OBJ_EDITION_NAME | VARCHAR2 | (128) | ||
| DBID | NUMBER | |||
| CON_ID | NUMBER | container id |
Cut, paste (and edit) the following text to query this object:
SELECT AUDIT_TYPE
, SESSION_ID
, PROXY_SESSIONID
, STATEMENTID
, ENTRYID
, EXTENDED_TIMESTAMP
, GLOBAL_UID
, DB_USER
, CLIENT_ID
, ECONTEXT_ID
, EXT_NAME
, OS_USER
, USERHOST
, OS_PROCESS
, TERMINAL
, INSTANCE_NUMBER
, OBJECT_SCHEMA
, OBJECT_NAME
, POLICY_NAME
, NEW_OWNER
, NEW_NAME
, ACTION
, STATEMENT_TYPE
, AUDIT_OPTION
, TRANSACTIONID
, RETURNCODE
, SCN
, COMMENT_TEXT
, SQL_BIND
, SQL_TEXT
, OBJ_PRIVILEGE
, SYS_PRIVILEGE
, ADMIN_OPTION
, OS_PRIVILEGE
, GRANTEE
, PRIV_USED
, SES_ACTIONS
, LOGOFF_TIME
, LOGOFF_LREAD
, LOGOFF_PREAD
, LOGOFF_LWRITE
, LOGOFF_DLOCK
, SESSION_CPU
, OBJ_EDITION_NAME
, DBID
, CON_ID
FROM SYS.CDB_COMMON_AUDIT_TRAIL;
SYS.CDB_COMMON_AUDIT_TRAIL does not reference any database object
SYS.CDB_COMMON_AUDIT_TRAIL is referenced by following:
PUBLIC
CDB_COMMON_AUDIT_TRAIL
|
|
|
|