Teradata Vantage 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:
| Status Indicator | Description |
|---|---|
| Y | Allowed but not required |
| N | Not Allowed |
| R | 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 columnSpecify 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 |
| N,n | Y | Y | Y | N |
| Y,y | Y | Y | Y | Y |
| A,a | Y | Y | Y | R |
| B,b | Y | Y | R | N |
| C,c | Y | Y | R | Y |
| D,d | Y | Y | R | R |
| E,e | Y | R | R | N |
| F,f | Y | R | R | Y |
| G,g | Y | R | R | R |
| H,h | N | Y | Y | N |
| I,i | N | Y | Y | Y |
| J,j | N | Y | Y | R |
| K,k | N | Y | R | N |
| L,l | N | Y | R | Y |
| M,m | N | Y | R | R |
| O,o | N | R | R | N |
| P,p | N | R | R | Y |
| R,r | N | R | R | R |