16.10 - Determining if a Password Contains a Restricted Word - Teradata Database

Teradata Database Security Administration

Product
Teradata Database
Release Number
16.10
Release Date
June 2017
Content Type
Administration
Security
Publication ID
B035-1100-161K
Language
English (United States)
  1. Remove all ASCII numbers and ASCII special characters from the beginning and end of the password string.
  2. Use the resulting string (the stripped password) in the query:
    SELECT*FROM DBC.PasswordRestrictions WHERE UPPER(RestrictWords)=UPPER(‘StrippedPassword’)