nerdexam
Oracle

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.

New Features for Database Infrastructure and Architecture

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)
  • A
    11% (5)
  • B
    2% (1)
  • C
    82% (37)
  • D
    4% (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.

ASystem privileges apply only to the PDB in which they are used.

Common system privileges granted with CONTAINER=ALL propagate to all PDBs in the CDB, not just the local PDB where the grant was issued.

BLocal users cannot use local system privileges on the schema of a common user.

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.

CThe granter of system privileges must possess the set container privilege.Correct

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.

DCommon users connected to a PDB can exercise privileges across other PDBs.

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.

ESystem privileges with the with grant option container all clause must be granted to a common userCorrect

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

#CDB system privileges#SET CONTAINER privilege#common user privileges#PDB privilege scope

Community Discussion

No community discussion yet for this question.

Full 1Z0-060 Practice