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.
See Also: See Oracle AI Database Security Guide for more information about mandatory user profiles