Change Database Profile and Password Verify Function

Within MODS Regular the following database profiles are available (pls. note that these profiles do limit password related parameters only; resource parameters are not limited):

• SC_PERSUSER standard database profile for personal user.
• SC_TECHUSER standard database profile for application and technical user.
• SC_PDBADMIN standard database profile for PDBADMIN and DBA accounts.

The table below lists the different limits of the MODS standard database profiles:

Resource Name	SC_PERSUSER	SC_TECHUSER	SC_PDBADMIN
failed_login_attempts	10	10	10
password_life_time	120	Unlimited	60
password_reuse_time	720	720	720
password_reuse_max	10	10	10
password_lock_time	Unlimited	Unlimited	Unlimited
password_grace_time	10	10	10
inactive_account_time	180	180	180
password_verify_function	sc_pvf_default_strong	sc_pvf_default_strong	sc_pvf_default_strong

Table: MODS Standard Database Profiles

Customers can modify the MODS standard database profiles by the ALTER PROFILE command. Example:

ALTER PROFILE sc_persuser LIMIT
PASSWORD_VERIFY_FUNCTION sc_pvf_verify_function;

Caution: an automatic PDB deployment may overwrite any customization on these profiles. Therefore we do not recommend to customize the MODS Regular standard profiles. Instead, we recommend to create a new database profile.

Since PDBADMIN cannot create its own password verification functions, MODS offers three password verification functions, which customers can use in their database profiles:

• SC_PVF_DEFAULT_STRONG default password verification function with min password length of 12 characters and additional verifications.
• SC_PVF_VERIFY_FUNCTION a less strict verification function with min password length of 8 characters and additional verifications.
• SC_PVF_STRONG_VERIFY_FUNCTION a verification function with min password length of 9 characters and additional verifications.

For details about the MODS standard database profiles see Password Verify Function.