Determining if a Password Contains a Restricted Word - Analytics Database - Teradata Vantage

Security Administration

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2024-04-05
dita:mapPath
hjo1628096075471.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
zuy1472246340572
lifecycle
latest
Product Category
Teradata Vantage™
  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’)