Thank you for visiting Spatial DBA - Oracle and ArcSDE.
I have stopped updating the blog.
Please visit Oracle DBA Tips (http://www.oracledbatips.com) for more Oracle DBA Tips.
====================================================================
Oracle 11gR1
DBA_AUDIT_EXISTS displays audit trail entries produced by AUDIT EXISTS and AUDIT NOT EXISTS.
Column | Datatype | NULL | Description |
OS_USERNAME | VARCHAR2(255) | Operating system login username of the user whose actions were audited | |
USERNAME | VARCHAR2(30) | Name (not ID number) of the user whose actions were audited | |
USERHOST | VARCHAR2(128) | Client host machine name | |
TERMINAL | VARCHAR2(255) | Identifier of the user's terminal | |
TIMESTAMP | DATE | Date and time of the creation of the audit trail entry (date and time of user login for entries created by AUDIT SESSION) in the local database session time zone | |
OWNER | VARCHAR2(30) | Intended creator of the non-existent object | |
OBJ_NAME | VARCHAR2(128) | Name of the object affected by the action | |
ACTION_NAME | VARCHAR2(28) | Name of the action type corresponding to the numeric code in the ACTION column in DBA_AUDIT_TRAIL | |
NEW_OWNER | VARCHAR2(30) | Owner of the object named in the NEW_NAME column | |
NEW_NAME | VARCHAR2(128) | New name of an object after a RENAME or the name of the underlying object | |
OBJ_PRIVILEGE | VARCHAR2(16) | Object privileges granted or revoked by a GRANT or REVOKE statement | |
SYS_PRIVILEGE | VARCHAR2(40) | System privileges granted or revoked by a GRANT or REVOKE statement | |
GRANTEE | VARCHAR2(30) | Name of the grantee specified in a GRANT or REVOKE statement | |
SESSIONID | NUMBER | NOT NULL | Numeric ID for each Oracle session |
ENTRYID | NUMBER | NOT NULL | Numeric ID for each audit trail entry in the session |
STATEMENTID | NUMBER | NOT NULL | Numeric ID for each statement run |
RETURNCODE | NUMBER | NOT NULL | Oracle error code generated by the action. Some useful values: · 0 - Action succeeded· 2004 - Security violation |
CLIENT_ID | VARCHAR2(64) | Client identifier in each Oracle session | |
ECONTEXT_ID | VARCHAR2(64) | Application execution context identifier | |
SESSION_CPU | NUMBER | Amount of CPU time used by each Oracle session | |
EXTENDED_TIMESTAMP | TIMESTAMP(6) WITH TIME ZONE | Timestamp of the creation of the audit trail entry (timestamp of user login for entries created by AUDIT SESSION) in UTC (Coordinated Universal Time) time zone | |
PROXY_SESSIONID | NUMBER | Proxy session serial number, if an enterprise user has logged in through the proxy mechanism | |
GLOBAL_UID | VARCHAR2(32) | Global user identifier for the user, if the user has logged in as an enterprise user | |
INSTANCE_NUMBER | NUMBER | Instance number as specified by the INSTANCE_NUMBER initialization parameter | |
OS_PROCESS | VARCHAR2(16) | Operating System process identifier of the Oracle process | |
TRANSACTIONID | RAW(8) | Transaction identifier of the transaction in which the object is accessed or modified | |
SCN | NUMBER | System change number (SCN) of the query | |
SQL_BIND | NVARCHAR2(2000) | Bind variable data of the query | |
SQL_TEXT | NVARCHAR2(2000) | SQL text of the query | |
OBJ_EDITION | VARCHAR2(30) | ??? |
Note:
The
SQL_BIND and SQL_TEXT columns are only populated if the AUDIT_TRAIL initialization parameter is set to db_extended.
No comments:
Post a Comment