15.00 - 3699 SysSecDefaults table has an invalid character value in a char column. - Teradata Database

Teradata Database Messages

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1096-015K
Language
English (United States)

3699 SysSecDefaults table has an invalid character value in a char column.

Explanation:

The character value in the PasswordDigits column of the table SysSecDefaults must be either a 'N' to indicate no (not allowed), an 'Y' to indicate yes (allowed but not required), or 'R' to indicate required. The character value in the PasswordSpecChar column of the table SysSecDefaults must be within the range of 'A' - 'P', 'R', or 'Y' as defined by the matrix below. This single character field represents the setting of four password control rules: 1) UserName allowed within the password string 2) Upper/Lower case characters within the password string 3) At least one alpha character within the password string 4) Special characters within the password string In the matrix below, to the right of each valid option character is a single character (Y, N, or R) to indicate how each of the four password control rules are set. 'N' indicates not allowed, 'Y' indicates allowed but not required (for rule Upper/Lower it means ignore case), and 'R' indicates required. Upper/ One Spec Option UserName Lower Alpha Chars N Y Y Y N Y Y Y Y Y A Y Y Y R B Y Y R N C Y Y R Y D Y Y R R E Y R R N F Y R R Y G Y R R R H N Y Y N I N Y Y Y J N Y Y R K N Y R N L N Y R Y M N Y R R O N R R N P N R R Y R N R R R

Generated By:

MgcSecOp.

For Whom:

Site Administrator.

Remedy:

Correct the value for the column in SysSecDefaults and restart Teradata.