15.10 - LogOnOffV[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)

Operations

DBC

 

View Column

Data Type

Format

Source Table.Column

LogDate

DATE

NOT NULL

YY/MM/DD

EventLog.DateFld (Composite NUPI)

LogTime

TIME

NOT NULL

99:99:99.99

EventLog.TimeFld (Composite NUPI)

UserName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(128)

EventLog.UserName

AccountName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(128)

EventLog.AccountName

Event

CHAR(12) LATIN

NOT CASESPECIFIC

NOT NULL

X(12)

EventLog.Event

LogicalHostId

SMALLINT

NOT NULL

ZZZ9 (explicit)

EventLog.LogicalHostId

IFPNo

SMALLINT

NOT NULL

-(5)9

EventLog.IFPNo

SessionNo

INTEGER

NOT NULL

--,---,---,--9 (explicit)

EventLog.SessionNo

LogonDate

DATE

NOT NULL

YY/MM/DD (explicit)

EventLog.DateFId

LogonTime

TIME

NOT NULL

99:99:99.99 (explicit)

EventLog.TimeFId

LogonSource

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

X(128)

EventLog.LogonSource

ClientIpAddress

VARCHAR(45)

UNICODE

X(45)

EventLog.ClientIpAddress

ClientProgramName

VARCHAR(1024)

UNICODE

X(1024)

EventLog.ClientProgramName

ClientSystemUserId

VARCHAR(128)

UNICODE

X(128)

EventLog.ClientSystemUserId

ClientConnectionType

BYTEINT

--9

EventLog.ClientConnectionType

ClientCoordName

VARCHAR(128)

UNICODE

X(128)

EventLog.ClientCoordName

ClientEnvName

VARCHAR(128)

UNICODE

X(128)

EventLog.ClientEnvName

ClientJobId

VARCHAR(128)

UNICODE

X(128)

EventLog.ClientJobId

ClientJobName

VARCHAR(128)

UNICODE

X(128)

EventLog.ClientJobName

ClientOsName

VARCHAR(128)

UNICODE

X(128)

EventLog.ClientOsName

ClientProcThreadId

VARCHAR(128)

UNICODE

X(128)

EventLog.ClientProcThreadId

ClientSecProdGrp

VARCHAR(128)

UNICODE

X(128)

EventLog.ClientSecProdGrp

ClientSecProdUserId

VARCHAR(128)

UNICODE

X(128)

EventLog.ClientSecProdUserId

ClientTcpPortNumber

INTEGER

--,---,---,--9

EventLog.ClientTcpPortNumber

ClientTdHostName

VARCHAR(128)

UNICODE

X(128)

EventLog.ClientTdHostName

ClientTerminalId

VARCHAR(128)

UNICODE

X(128)

EventLog.ClientTerminalId

ClientTransactionId

VARCHAR(128)

UNICODE

X(128)

EventLog.ClientTransactionId

ClientUserOperId

VARCHAR(128)

UNICODE

X(128)

EventLog.ClientUserOperId

ClientVmName

VARCHAR(128)

UNICODE

X(128)

EventLog.ClientVmName

ClientVmUserId

VARCHAR(128)

UNICODE

X(128)

EventLog.ClientVmUserId

MechanismName

VARCHAR(128)

UNICODE

X(128)

EventLog.MechanismName

ClientTDPReleaseId

VARCHAR(128)

UNICODE

X(128)

EventLog.ClientTDPReleaseId

ClientCLIv2ReleaseId

VARCHAR(128)

UNICODE

X(128)

EventLog.ClientCLIv2ReleaseId

ClientSessionDesc

VARCHAR(128)

UNICODE

X(128)

EventLog.ClientSessionDesc

ClientWorkload

VARCHAR(128)

UNICODE

X(128)

EventLog.ClientWorkload

ClientJobData

VARCHAR(128)

UNICODE

X(128)

EventLog.ClientJobData

ClientODBCDriverVersion

VARCHAR(16)

CHARACTER SET

UNICODE

NOT CASESPECIFIC

X(16)

SessionTbl.ClientInterfaceVersion

ClientNetDataProviderVersion

VARCHAR(16)

CHARACTER SET

UNICODE

NOT CASESPECIFIC

X(16)

SessionTbl.ClientInterfaceVersion

ClientODBCDriverManager
Version

CHAR(30)

CHARACTER SET

UNICODE

NOT CASESPECIFIC

X(30)

SessionTbl.ClientAttributesEx

ClientNetFrameworkVersion

CHAR(30)

CHARACTER SET

UNICODE

NOT CASESPECIFIC

X(30)

SessionTbl.ClientInterfaceVersion

ClientAttributesEx

VARCHAR(512)

UNICODE

X(512)

EventLog.ClientAttributesEx

ClientJDBCDriverVersion

VARCHAR(16)

UNICODE

X(16)

None

ClientJavaVersion

VARCHAR(30)

UNICODE

X(30)

None

RecoverableNetworkProtocol

CHAR(1) LATIN

NOT NULL

X(1)

EventLog.RecoverableNetwork
Protocol

LogonRedrive

VARCHAR(33)

UNICODE

X(33)

EventLog.LogonRedrive

ClientIPAddrByClient

VARCHAR(45)

UNICODE

X(45)

EventLog.ClientIPAddrByClient

ClientPortByClient

INTEGER

--,---,---,--9

EventLog.ClientPortByClient

ServerIPAddrByClient

VARCHAR(45)

UNICODE

X(45)

EventLog.ServerIPAddrByClien

ServerPortByClient

INTEGER

--,---,---,--9

EventLog.ServerPortByClient

ClientIPAddrByUnity

VARCHAR(45)

UNICODE

X(45)

EventLog.ClientIPAddrByUnity

ClientPortByUnity

INTEGER

--,---,---,--9

EventLog.ClientPortByUnity

UnityClientSideIPAddr

VARCHAR(45)

UNICODE

X(45)

EventLog.UnityClientSideIPAddr

UnityClientSidePort

INTEGER

--,---,---,--9

EventLog.UnityClientSidePort

UnityServerSideIPAddr

VARCHAR(45)

UNICODE

X(45)

EventLog.UnityServerSideIPAddr

UnityServerSidePort

INTEGER

--,---,---,--9

EventLog.UnityServerSidePort

ServerIPAddrByUnity

VARCHAR(45)

UNICODE

X(45)

EventLog.ServerIPAddrByUnity

ServerPortByUnity

INTEGER

--,---,---,--9

EventLog.ServerPortByUnity

ServerIPAddrByServer

VARCHAR(45)

UNICODE

X(45)

EventLog.ServerIPAddrByServer

ServerPortByServer

INTEGER

--,---,---,--9

EventLog.ServerPortByServer

ClientCOPSuffixedHost
Name

VARCHAR(128)

UNICODE

X(128)

EventLog.ClientCOPSuffixedHost
Name

UnitySessNo

INTEGER

--,---,---,--9

EventLog.UnitySessNo

UnityVersion

VARCHAR(128)

UNICODE

X(128)

EventLog.UnityVersion

UnityAuthMechName

VARCHAR(1571)

UNICODE

X(1571)

EventLog.UnityAuthMechName

UnityMechanismName

VARCHAR(1571)

UNICODE

X(1571)

EventLog.UnityMechanismName

UserAuthenticatedBy

VARCHAR(1)

UNICODE

X(1)

EventLog.UserAuthenticatedBy

ClientTDSessionPool
Name

VARCHAR(128)

UNICODE

X(128)

EventLog.ClientTDSessionPool
Name

UnityTcpPortNumber

INTEGER

--,---,---,--9

EventLog.UnityTcpPortNumber

UnityIpAddress

VARCHAR(45)

UNICODE

X(45)

EventLog.UnityIpAddress

SecurityPolicy

VARCHAR(256)

UNICODE

NOT CASESPECIFIC

X(256)

EventLog.RFU1

UnitySecurityPolicy

VARCHAR(256)

UNICODE

NOT CASESPECIFIC

X(256)

EventLog.RFU2

Unity_AuthUser

VARCHAR(256)

UNICODE

NOT CASESPECIFIC

X(256)

EventLog.RFU3

UnityProxyLogon

VARCHAR(256)

UNICODE

NOT CASESPECIFIC

X(256)

EventLog.RFU4

Account Name

The AccountName column is the current unexpanded account name for the session.

LogonSource

Teradata recommends using alternative columns instead of the LogonSource column, if available. For information about the recommended columns for LogonSource, see Appendix B: “LogonSource Column Fields and Examples.”

Possible Values for ClientConnectionType

 

Value

Description

1

Client is connected using TCP/IP via the gateway.

2

Client is connected from a mainframe via a mainframe-attached host.

Possible Values for Event

Note: The names of the following values are truncated if they are more than 12 characters in length. If they are less than 12 characters in length, blank spaces are added.

  • Logon
  • Logoff
  • Logon failed
  • This value means a logon failed for reasons other than “Bad User,” “Bad Account,” “Bad Password,” “Bad profile,” “IP restrict,” “Auth failed,” “Bad auth,” or “Secur policy.” Currently, those other reasons are a failure to conform to Logon Rules or an attempt to log on without a password, where the TDP logon exit does not approve the logon.

  • Bad user
  • Bad account
  • This value means the user provided an account string during logon time, but that string does not match any of the account names specified for the user in the SQL CREATE USER or MODIFY USER statement.

  • Bad password
  • Bad profile
  • The external profile associated with the logon request does not exist. External profiles are stored in the directory server.

  • Forced off
  • This value indicates that the user session was terminated from the Teradata Database console or the PM/API.

  • IP restrict
  • This value indicates the user is not permitted to log on from the IP address used.

  • Auth failed
  • This value indicates an authentication error.

  • Bad auth
  • This value may indicate other authentication errors: bad authentication field, deprecated logons, decryption failure, and so forth.

  • Secur policy
  • This value indicates that a logon attempt failed because of a security policy violation.

    Possible Values for LogonRedrive

     

    Value

    Description

    ' '

    Not participating

    MEMORY NON-FALLBACK RESPONSES

    Memory-based Redrive participation

    NULL or blanks

    Session is not participating in Redrive and database restarts will not be transparent to applications and users.

    Possible Values for RecoverableNetworkProtocol

     

    Value

    Description

    T

    True

    F

    False

    Possible Values for SecurityPolicy and UnitySecurityPolicy

  • No Policy
  • Plaintext
  • Integrity, Default
  • Integrity, Low
  • Integrity, Medium
  • Integrity, High
  • Confidentiality, Default
  • Confidentiality, Low
  • Confidentiality, Medium
  • Confidentiality, High
  • The source table columns for SecurityPolicy (DBC.EventLog.RFU1) and UnitySecurityPolicy (DBC.EventLog.RFU2) are used to provide audit trail information for the security policy.

    Possible Values for UnityProxyLogon

    The UnityProxyLogon column indicates if a TD2 logon without a password has occurred. Unity Director can log on a TD2 session using the PROXY mechanism on a managed database system, after the same user has successfully been logged on to another managed database system.

     

    Value

    Description

    T

    True indicates the TD2 session logged onto a managed database from Unity Director with no password after the user successfully logged onto another managed database.

    F

    False indicates the TD2 session logged on or attempted to log on with a password.

    Unity_AuthUser

    The source table column for Unity_AuthUser (DBC.EventLog.RFU3) is used to provide the audit trail information for the security policy.

    UserName

    The UserName column returns “Non-existent User” when a user tries to log on with a bad username.

    The following SELECT statement displays information about the type of security policy enforced by the Gateway:

    ==> SELECT Logdate,Logtime,Event,SessionNo,SecurityPolicy,UnitySecurityPolicy,
    Unity_AuthUser 
           FROM LogonOffV WHERE UnitySecurityPolicy is not NULL 
           ORDER BY Logdate,LogTime;

    Result:

          LogDate 12/11/08
          LogTime 13:55:47.86
           Event Bad User
         SessionNo     1,001
       SecurityPolicy No Policy
    UnitySecurityPolicy No Policy
       Unity_AuthUser CN=proxyconfhigh,DC=jrrlinux
          LogDate 12/11/08
          LogTime 14:12:26.11
           Event Bad User
         SessionNo     1,002
       SecurityPolicy No Policy
    UnitySecurityPolicy No Policy
       Unity_AuthUser CN=proxyconfhigh,DC=jrrlinux
     

    For more information about ...

    See ...

    how to control access, space, and ownership

    Database Design.

    the security policy (either enforced by Gateway or Unity Director) and the Unity Director user

    Security Administration.