Allowable Values - Advanced SQL Engine - Teradata Database

Security Administration

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
September 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
ied1556235912841.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1100
lifecycle
previous
Product Category
Teradata Vantageā„¢

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