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

ExpirePassword

SMALLINT

NOT NULL

---,--9

SysSecDefaults.ExpirePassword

PasswordMinChar

BYTEINT

NOT NULL

--9

SysSecDefaults.PasswordMinChar

PasswordMaxChar

BYTEINT

NOT NULL

--9

SysSecDefaults.PasswordMaxChar

PasswordDigits

CHAR(1) LATIN

UPPERCASE

NOT NULL

X(1)

SysSecDefaults.PasswordDigits

PasswordSpecChar

CHAR(1) LATIN

UPPERCASE

NOT CASESPECIFIC

NOT NULL

X(1)

SysSecDefaults.PasswordSpecChar

PasswordRestrictWords

CHAR(1) LATIN

UPPERCASE

NOT NULL

X(1)

SysSecDefaults.PasswordRestrictWords

MaxLogonAttempts

BYTEINT

NOT NULL

---9 (explicit)

SysSecDefaults.MaxLogonAttempts

LockedUserExpire

SMALLINT

NOT NULL

---,--9 (explicit)

SysSecDefaults.LockedUserExpire

PasswordReuse

SMALLINT

NOT NULL

---,--9 (explicit)

SysSecDefaults.PasswordReUse

For more information about controlling access, space, and ownership, see the following manuals:

  • Database Administration
  • Database Design
  • Security Administration