Modifying SysSecDefaults table

Database
RB
Enthusiast

Modifying SysSecDefaults table

Hello Forum,

 

Have couple questions regarding this table. 

 

1) Would making changes to this table require a restart for the chnages to take effect?

2) Also if a user is attached to 'NO' profile and then would this defaults in this table take effect?

3) Will the rules take effect only for new users or even the existing users ? For rules like 'Maxpasswordlength' or 'Password Reuse' etc? 

 

Thanks


Accepted Solutions
Teradata Employee

Re: Modifying SysSecDefaults table

2) Yes, if the User has no Profile assigned, or if the field in the profile is NULL, then the corresponding field in SysSecDefaults will be used. 

3) Rules apply to existing users as well as new users, but note that Password Expiration is enforced when the user attempts to log on, and restrictions are enforced when the user attempts to change an existing password. (An existing password won't be edited, just a password change attempt.)  This is also important to understand for "admin" users that can change other users' passwords - the rules for the "modifying" user apply to the password change, not the rules for the user being modified.

1 ACCEPTED SOLUTION
3 REPLIES 3
RB
Enthusiast

Re: Modifying SysSecDefaults table

Got the answer for 1). It does need a restart for the change to take effect. 

Teradata Employee

Re: Modifying SysSecDefaults table

2) Yes, if the User has no Profile assigned, or if the field in the profile is NULL, then the corresponding field in SysSecDefaults will be used. 

3) Rules apply to existing users as well as new users, but note that Password Expiration is enforced when the user attempts to log on, and restrictions are enforced when the user attempts to change an existing password. (An existing password won't be edited, just a password change attempt.)  This is also important to understand for "admin" users that can change other users' passwords - the rules for the "modifying" user apply to the password change, not the rules for the user being modified.

RB
Enthusiast

Re: Modifying SysSecDefaults table

Thanks Fred!! This clarifies.