15.10 - LogonRulesV - 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

UserName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(128)

Dbase.DatabaseName

LogicalHostId

SMALLINT

NOT NULL

ZZZ9 (explicit)

LogonRuleTbl.LogicalHostId (Composite UPI)

LogonStatus

CHAR(1) LATIN

NOT CASESPECIFIC

NOT NULL

X(1)

LogonRuleTbl.LogonStatus

NullPassword

CHAR(1) LATIN

NOT CASESPECIFIC

NOT NULL

X(1)

LogonRuleTbl.NullPassword

CreatorName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

X(128)

Dbase.DatabaseName

CreateTimeStamp

TIMESTAMP(0)

YYYY-MM-DDBHH:MI:SS

LogonRuleTbl.CreateTimeStamp

The LogonRules view retrieves information about logon rules generated as a result of successfully processed GRANT LOGON/REVOKE LOGON statements.

The LOGON rules can be used to redefine the SQL Data Control Language defaults. For more information, see SQL Data Control Language.

The initial default is that all users can log on from all connected client systems.