PasswordRestrictWords - Advanced SQL Engine - Teradata Database

Security Administration

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

The PasswordRestrictWords parameter determines whether a password is subject to the content restrictions defined in the RestrictedWords list. The system contains a default set of Restricted Words, and you can add others. See Password Restricted Words.

The system trims special characters from a password before comparing it to the list of password restricted words. The definition of special characters is determined as follows:
  • Upper includes all UNICODE characters in General Category Class Lu.
  • Lower includes all UNICODE characters in General Category Class Ll.
  • Alpha includes all UNICODE characters that are in either Upper (Lu) or Lower (Ll)
  • Special indicates characters that are neither Alpha nor any of the characters 0 through 9 (U+0030 – U+0039). By this definition, un-cased letters (General Category Class Lo) are considered Special (for example, Arabic, Chinese or Hebrew characters). Likewise numeric digits (General Category Class Nd) other than the characters 0 through 9 (U+0030 – U+0039) are classified as Special.

A character with non-zero combining class is trimmed only if the character immediately preceding it is also trimmed. (Combining characters are characters that have a non-zero combining class and non-combining characters are those with a combining class of zero.)

For example, an accent is a combining character. If the character A is followed by an accent mark or two, the accent marks are not trimmed. Alternatively, if a multiplication sign is followed by two accents, the accents and the multiplication sign are trimmed.