MANDATORY_USER

2.198 MANDATORY_USER_PROFILE

MANDATORY_USER_PROFILE specifies the mandatory user profile for a CDB or PDB.

Property	Description
Parameter type	String
Syntax	`MANDATORY_USER_PROFILE = profile_name`
Default value	There is no default value
Modifiable	`ALTER SYSTEM`
Modifiable in a PDB	Yes
Basic	No
Oracle RAC	Multiple instances must use the same value.

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.

Note:

This parameter is available starting with Oracle Database 21c.