Category: Security
Database: DBC
| View Column | Data Type | Format | Comment |
|---|---|---|---|
| LogDate | DATE NOT NULL | YY/MM/DD | Returns the date that the access log entry was made. |
| LogTime | FLOAT NOT NULL | 99:99:99 | Returns the time of day that the event occurred as HH:MM:SS. |
| LogType | SMALLINT | ---,--9 | Returns the kind of statement for which the access log entry was made. |
| UserName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | Returns 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. SYSTEMACCOUNTNO tracks console utility activity such as table rebuild, Diskcopy, or Scandisk. |
| DatabaseName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | Returns 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) | Returns 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. |