Mandatory Profile in Oracle Database
As you know, profiles can be used to impose restrictions on each user in two areas: resource consumption and password complexity . Profiles are set at the user level, and each user can have only one profile. In Oracle 21c , a new type of profile called Mandatory Profile was introduced. It can be created at the root container level and can be assigned to one or more PDBs. In this case, the policies defined in the profile will apply to all users in the assigned PDB(s). A Mandatory Profile is specifically intended to enforce password-related restrictions, such as ensuring that a user’s password has at least n characters. These restrictions can be implemented by creating a FUNCTION and assigning it to the PASSWORD_VERIFY_FUNCTION parameter in the profile. Example: In this example, by creating a function func_pass_limit and using it in a Mandatory Profile, we aim to enforce a restriction...
