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. |
LogonDate | DATE NOT NULL | YY/MM/DD | Returns the date that the session for which the log entry was made was logged on to the Teradata Database. |
LogonTime | FLOAT NOT NULL | 99:99:99 | Returns the time on which logon for the session occurred (useful on logoff events). |
LogicalHostId | SMALLINT NOT NULL | ZZZ9 | Returns a unique identifier of the logon source for the logged query. A value of zero indicates an internal session. |
IFPNo | SMALLINT NOT NULL | -(5)9 | Returns the vproc number of the PE through which the session was connected or assigned. |
SessionNo | INTEGER NOT NULL | --,---,---,--9 | Returns the session identifier assigned to the session by the TDP or LAN interface. |
UserName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | The AccessLogV.UserName field shows the name of the user who was using the session. |
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. |
OwnerName | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | The AccessLogV.OwnerName field shows the user whose rights are being logged when a macro or view references other objects. |
AccessType | CHAR(2) LATIN NOT CASESPECIFIC NOT NULL | X(2) | (for "Acr"-type columns) Returns the type of privilege for which the check that generated this log entry was performed. |
Frequency | CHAR(1) LATIN NOT CASESPECIFIC NOT NULL | X(1) | Logging frequency (occurrences): B (FIRST and LAST), E (each), F (first), L (last). |
EventCount | INTEGER | --,---,---,--9 | Returns the number of duplicate rows (that is, same occurrences) that preceded a 'LAST-occurrence- only' row. |
AccLogResult | CHAR(1) LATIN NOT CASESPECIFIC NOT NULL | X(1) | Returns a code to indicate how the access request for which this log entry was made. |
DatabaseName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | Returns the database or user name of the object for which this log entry was made. |
TVMName | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | Returns the table, view, stored procedure, macro, user-defined types, user-defined methods, or user-defined function name of the object for which this log entry was made. |
ColumnName | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | The AccessLogV.ColumnName field shows the name of the column which was entered on the access log. |
StatementType | VARCHAR(20) LATIN NOT CASESPECIFIC NOT NULL | X(20) | Statement type issued by the query. Final statement type in a multistatement request. |
StatementText | VARCHAR(8192) UNICODE NOT CASESPECIFIC | X(8192) | Returns (if so defined in the associated rule) the text of the statement that caused the privilege check for which this log entry was made. |
QueryBand | VARCHAR(12304) UNICODE NOT CASESPECIFIC | X(12304) | Returns the band under which the query is submitted. |
ProxyUser | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | Returns the name of the proxy user. |
ConstraintId | BYTE(4) | X(8) | The AccessLogV.ConstraintId field shows the id of the security constraint which was entered on the access log. |