Category: Security
Database: DBC
| View Column | Data Type | Format | Description |
|---|---|---|---|
| LogDate | DATE NOT NULL | YYYY/MM/DD | The date that the access log entry was made. |
| LogTime | FLOAT NOT NULL | 99:99:99 | The time of day that the event occurred as HH:MM:SS. |
| LogType | SMALLINT | ---,--9 | Type of statement for which access log entry was made. |
| UserName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | The name of the user for whom the log entry was made. |
| AccountName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | Expanded account in effect when a request was submitted. |
| DatabaseName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | The name of the database or user of the object for which this log entry was made. |
| TableName | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | The name of the table, view, stored procedure, or macro for this log entry. |
| Text | VARCHAR(8192) UNICODE NOT CASESPECIFIC | X(8192) | Text for the numbered event in the error log. |