17.10 - Allowable Values - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Advanced SQL Engine Security Administration

Advanced SQL Engine
Teradata Database
Release Number
July 2021
English (United States)
Last Update

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