DBA_AUDIT_TRAIL

SQL> DESC DBA_AUDIT_TRAIL

 Name                                     Null?              Type
 -----------------------------------------------------------------------------
 OS_USERNAME                                        VARCHAR2(255)
 USERNAME                                               VARCHAR2(30)
 USERHOST                                                VARCHAR2(128)
 TERMINAL                                                VARCHAR2(255)
 TIMESTAMP                                              DATE
 OWNER                                                     VARCHAR2(30)
 OBJ_NAME                                               VARCHAR2(128)
 ACTION                      NOT NULL            NUMBER
 ACTION_NAME                                        VARCHAR2(28)
 NEW_OWNER                                          VARCHAR2(30)
 NEW_NAME                                             VARCHAR2(128)
 OBJ_PRIVILEGE                                       VARCHAR2(16)
 SYS_PRIVILEGE                                       VARCHAR2(40)
 ADMIN_OPTION                                       VARCHAR2(1)
 GRANTEE                                                  VARCHAR2(30)
 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                           NOT NULL           NUMBER
 ENTRYID                              NOT NULL            NUMBER
 STATEMENTID                    NOT NULL           NUMBER
 RETURNCODE                     NOT NULL           NUMBER
 PRIV_USED                                                         VARCHAR2(40)
 CLIENT_ID                                                         VARCHAR2(64)
 ECONTEXT_ID                                                 VARCHAR2(64)
 SESSION_CPU                                                  NUMBER
 EXTENDED_TIMESTAMP                                 TIMESTAMP(6) WITH TIME ZONE
 PROXY_SESSIONID                                         NUMBER
 GLOBAL_UID                                                  VARCHAR2(32)
 INSTANCE_NUMBER                                    NUMBER
 OS_PROCESS                                                  VARCHAR2(16)
 TRANSACTIONID                                            RAW(8)
 SCN                                                                   NUMBER
 SQL_BIND                                                       NVARCHAR2(2000)
 SQL_TEXT                                                       NVARCHAR2(2000)
 OBJ_EDITION_NAME                                   VARCHAR2(30)

No comments:

Post a Comment