AccessLogV - Advanced SQL Engine - Teradata Database

Data Dictionary

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-10-15
dita:mapPath
yoz1556235523563.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1092
lifecycle
previous
Product Category
Teradata Vantageā„¢

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.