[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | CDB_AUDIT_TRAIL |
|---|---|
| Object Type: | VIEW |
| Owner: | SYS |
| Subobject Name: | |
| Status: | VALID |
All audit trail entries in all containers
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| OS_USERNAME | VARCHAR2 | (255) | Operating System logon user name of the user whose actions were audited | |
| USERNAME | VARCHAR2 | (128) | Name (not ID number) of the user whose actions were audited | |
| USERHOST | VARCHAR2 | (128) | Client host machine name | |
| TERMINAL | VARCHAR2 | (255) | Identifier for the user's terminal | |
| TIMESTAMP | DATE | Date/Time of the creation of the audit trail entry (Date/Time of the user's logon for entries created by AUDIT SESSION) in session's time zone | ||
| OWNER | VARCHAR2 | (128) | Creator of object affected by the action | |
| OBJ_NAME | VARCHAR2 | (128) | Name of the object affected by the action | |
| ACTION | NUMBER | Yes | Numeric action type code. The corresponding name of the action type (CREATE TABLE, INSERT, etc.) is in the column ACTION_NAME | |
| ACTION_NAME | VARCHAR2 | (28) | Name of the action type corresponding to the numeric code in ACTION | |
| NEW_OWNER | VARCHAR2 | (128) | The 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) | |
| OBJ_PRIVILEGE | VARCHAR2 | (16) | Object privileges granted/revoked by a GRANT/REVOKE statement | |
| SYS_PRIVILEGE | VARCHAR2 | (40) | ||
| ADMIN_OPTION | VARCHAR2 | (1) | ||
| GRANTEE | VARCHAR2 | (128) | ||
| AUDIT_OPTION | VARCHAR2 | (40) | ||
| SES_ACTIONS | VARCHAR2 | (19) | ||
| LOGOFF_TIME | DATE | |||
| LOGOFF_LREAD | NUMBER | |||
| LOGOFF_PREAD | NUMBER | |||
| LOGOFF_LWRITE | NUMBER | |||
| LOGOFF_DLOCK | VARCHAR2 | (40) | ||
| COMMENT_TEXT | VARCHAR2 | (4000) | ||
| SESSIONID | NUMBER | Yes | ||
| ENTRYID | NUMBER | Yes | ||
| STATEMENTID | NUMBER | Yes | ||
| RETURNCODE | NUMBER | Yes | ||
| PRIV_USED | VARCHAR2 | (40) | ||
| CLIENT_ID | VARCHAR2 | (128) | ||
| ECONTEXT_ID | VARCHAR2 | (64) | ||
| SESSION_CPU | NUMBER | |||
| EXTENDED_TIMESTAMP | TIMESTAMP(6) WITH TIME ZONE | (20) | ||
| PROXY_SESSIONID | NUMBER | |||
| GLOBAL_UID | VARCHAR2 | (32) | ||
| INSTANCE_NUMBER | NUMBER | |||
| OS_PROCESS | VARCHAR2 | (16) | ||
| TRANSACTIONID | RAW | (8) | ||
| SCN | NUMBER | |||
| SQL_BIND | NVARCHAR2 | (4000) | ||
| SQL_TEXT | NVARCHAR2 | (4000) | ||
| OBJ_EDITION_NAME | VARCHAR2 | (128) | ||
| DBID | NUMBER | |||
| CON_ID | NUMBER | container id |
Cut, paste (and edit) the following text to query this object:
SELECT OS_USERNAME
, USERNAME
, USERHOST
, TERMINAL
, TIMESTAMP
, OWNER
, OBJ_NAME
, ACTION
, ACTION_NAME
, NEW_OWNER
, NEW_NAME
, OBJ_PRIVILEGE
, SYS_PRIVILEGE
, ADMIN_OPTION
, GRANTEE
, AUDIT_OPTION
, SES_ACTIONS
, LOGOFF_TIME
, LOGOFF_LREAD
, LOGOFF_PREAD
, LOGOFF_LWRITE
, LOGOFF_DLOCK
, COMMENT_TEXT
, SESSIONID
, ENTRYID
, STATEMENTID
, RETURNCODE
, PRIV_USED
, CLIENT_ID
, ECONTEXT_ID
, SESSION_CPU
, EXTENDED_TIMESTAMP
, PROXY_SESSIONID
, GLOBAL_UID
, INSTANCE_NUMBER
, OS_PROCESS
, TRANSACTIONID
, SCN
, SQL_BIND
, SQL_TEXT
, OBJ_EDITION_NAME
, DBID
, CON_ID
FROM SYS.CDB_AUDIT_TRAIL;
SYS.CDB_AUDIT_TRAIL does not reference any database object
SYS.CDB_AUDIT_TRAIL is referenced by following:
PUBLIC
CDB_AUDIT_TRAIL
|
|
|
|