16.10 - Allowable Values - Teradata Database

Teradata Database Security Administration

Teradata Database
June 2017

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:

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