1Z0-060 · Question #115
Which two statements are true about the working of system privileges in a multitenant control database (CDB) that has pluggable databases (PDBs)?
The correct answer is C. The granter of system privileges must possess the set container privilege. E. System privileges with the with grant option container all clause must be granted to a common user. In a CDB, granting system privileges with CONTAINER=ALL requires the grantor to hold the SET CONTAINER privilege, and such grants can only be made to common users.
Question
Which two statements are true about the working of system privileges in a multitenant control database (CDB) that has pluggable databases (PDBs)?
Options
- ASystem privileges apply only to the PDB in which they are used.
- BLocal users cannot use local system privileges on the schema of a common user.
- CThe granter of system privileges must possess the set container privilege.
- DCommon users connected to a PDB can exercise privileges across other PDBs.
- ESystem privileges with the with grant option container all clause must be granted to a common user
How the community answered
(45 responses)- A11% (5)
- B2% (1)
- C82% (37)
- D4% (2)
Why each option
In a CDB, granting system privileges with CONTAINER=ALL requires the grantor to hold the SET CONTAINER privilege, and such grants can only be made to common users.
Common system privileges granted with CONTAINER=ALL propagate to all PDBs in the CDB, not just the local PDB where the grant was issued.
Local users can exercise locally granted system privileges on objects within their own PDB, including schemas owned by common users that reside in that same PDB.
To grant system privileges with CONTAINER=ALL (scoped to the root and all PDBs), the grantor must hold the SET CONTAINER privilege, which is a hard prerequisite for performing any common grant across the multitenant architecture.
Common users cannot exercise privileges from one PDB against objects in a different PDB without explicitly using SET CONTAINER to switch containers first; cross-PDB privilege exercise is not automatic.
The CONTAINER=ALL clause is restricted exclusively to grants targeting common users - it cannot be applied to local users - ensuring that privileges spanning all containers are only assigned to identities that exist CDB-wide.
Concept tested: CDB system privilege scoping and CONTAINER=ALL grant rules
Source: https://docs.oracle.com/database/121/DBSEG/authorization.htm
Topics
Community Discussion
No community discussion yet for this question.