Teradata Database has simplified the setup of special character options by allowing a single character to represent each valid combination of the four options.
- Special characters are allowed in a password
- Username is allowed in the password string
- Alpha characters are allowed but not required
- Mixed upper and lower case characters are allowed but not required
The values are not case sensitive.
Use the following rule key when you choose the combination of special character options you want to use:
|Y||Allowed but not required|
If you enter a value other than Y, N, or R, the system reverts to the default value and writes an error message to the event log:3699: SysSecDefaults table has an invalid character value in a char column
Specify the SpecChar single-letter option code with the set of status indicators that represents how you want to enforce the four SpecChar options.
|Included Special Character Option Rules|
|SPECCHAR OptionCode||UserName||Mixture of Upper and Lower Case letters||At least One Alpha Character||Special Characters|