17.10 - Comparing Global and Profile-Based Password Controls - 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

The security administrator can reset the password control parameters shown in the SysSecDefaults table in the following ways.

Password controls do not affect externally authenticated users because the database does not validate their passwords.
Reset Method Description Effects
Change a parameter value using an UPDATE statement Resets the control globally.
This is a global reset that causes the system to undo all default control values for affected parameters.
  • Global password controls apply to all users defined in the database.
  • DBC.SysSecDefaults table only at database startup. You must restart the database to enable changed values.
Password changes can take place when:
  • You modify an existing user definition, or a user modifies his or her own user definition, using a MODIFY USER statement.
  • A password expires and the user creates a new password.
CREATE/MODIFY PROFILE Resets global password control parameter(s) only for members of the profile.
Changes take effect at the next user logon.
Profile-based password controls apply only to the children of profile member users. To assign password controls to administrative users, you must assign a profile that contains the controls to a super administrator, who can then pass the controls down to other administrative users. Also see Effects of Profile-Based Password Controls.