For profile_name, specify the name of a mandatory user profile. Mandatory user profiles are common profiles created in the CDB root with the following SQL statement:

CREATE MANDATORY PROFILE ... CONTAINER = ALL;

You can set the value of MANDATORY_USER_PROFILE in the CDB root or in a PDB.

• When you set this parameter in the CDB root, the specified mandatory user profile applies to the CDB root and all PDBs.

• When you set this parameter in a PDB, the specified mandatory user profile applies only to that PDB and overrides the mandatory user profile for the CDB root, if any.

Only common users with the commonly granted ALTER SYSTEM privilege or the commonly granted SYSDBA privilege can set the value of MANDATORY_USER_PROFILE in the CDB root or in a PDB. This prevents local PDB administrators from circumventing any restrictions that are enforced at the CDB root.