16.10 - Comparing Global and Profile-Based Password Controls - Teradata Database

Teradata Database Security Administration

prodname
Teradata Database
vrm_release
16.10
created_date
June 2017
category
Administration
Security
featnum
B035-1100-161K

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.
  • Teradata 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.