Oracle Database 12c: Advanced Administration — Question 151

Which three statements are true about common roles?

Answer options

• A. A common role can be granted only to a common user.
• B. Only system privileges can be granted to a common role in a container database (CDB).
• 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 in a PDB.
• E. A common role cannot be created by a local user.

Correct answer: C, D, E

Explanation

The correct answer includes C, D, and E because object privileges can indeed be granted to a common role in a PDB, a common user can grant roles to others, and local users lack the ability to create common roles. Options A and B are incorrect as they misrepresent the capabilities associated with common roles and their privileges.