Which three statements are true about common roles?

The correct answer is C. Object privileges can be granted to a common role in a pluggable database (PDB). D. A common user that is granted a common role can grant the role to other common and local users E. A common role cannot be created by a local user. C: Commonly granted privileges that have been made to the common role apply in the root and all PDBs to which the grantor can connect, including PDBs that may be added later on. D: Common users can both create and grant common roles to other common and local users. E: Local…

Managing Database Security

Question

Which three statements are true about common roles?

Options

AA common role can be granted only to a common user.
BOnly system privileges can be granted to a common role in a container database (CDB).
CObject privileges can be granted to a common role in a pluggable database (PDB).
DA common user that is granted a common role can grant the role to other common and local users
EA common role cannot be created by a local user.

How the community answered

(32 responses)

A
6% (2)
B
13% (4)
C
81% (26)

Explanation

C: Commonly granted privileges that have been made to the common role apply in the root and all PDBs to which the grantor can connect, including PDBs that may be added later on. D: Common users can both create and grant common roles to other common and local users. E: Local users cannot create common roles. Note: A common role is a role that is created in the root; a local role is created in a PDB. Incorrect Answers: A: Local users can grant common roles to common and other local users.

Topics

#common roles#CDB security#role grants#local user restrictions

Community Discussion

No community discussion yet for this question.

Full 1Z0-063 Practice