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.
|
Password changes can take place when:
|
CREATE/MODIFY PROFILE | Resets global password control parameters 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. |