15.10 - SecurityLogV[X] - Teradata Database

Teradata Database Data Dictionary

Product
Teradata Database
Release Number
15.10
Content Type
Administration
User Guide
Publication ID
B035-1092-151K
Language
English (United States)

Security

DBC

 

View Column

Data Type

Format

Source Table.Column

LogDate

DATE

NOT NULL

YY/MM/DD (explicit)

AccLogTbl.TheDate

LogTime

TIME

NOT NULL

99:99:99 (explicit)

AccLogTbl.TheTime

LogType

SMALLINT

---,--9

AccLogTbl.StatementKind

UserName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(128)

AccLogTbl.UserName

AccountName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(128)

AccLogTbl.AccountName

DatabaseName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(128)

AccLogTbl.DatabaseName

TableName

VARCHAR(128)

UNICODE

X(128)

AccLogTbl.TVMName

Text

VARCHAR(8192)

UNICODE

X(8192)

AccLogTbl.StatementText

The corresponding table for DBC.SecurityLogV is DBC.AccLogTbl.

The corresponding tables for DBC.SecurityLogV[X] are:

  • DBC.AccLogTbl
  • DBC.DBase
  • DBC.Owners
  • This view also references the userdb view.

    Note: The DatabaseName column was previously named ObjectName.

    Possible Values for Partition

     

    Value

    Description

    DBC/SQL

    SQL Session

    EXPORT

    FASTEXPORT

    FASTLOAD

    FASTLOAD session

    HUTPARSE

    ARC data session

    MLOAD

    MULTILOAD session

    MONITOR

    Sessions running in a performance monitoring application

    NONE

    Session is recognized but not yet assigned