Oracle Database 12c: Advanced Administration — Question 15

Which two statements are true about roles in multitenant container databases (CDBs)?

Answer options

• A. Local roles can be granted to local and common users.
• B. A common role can be granted only to a common user.
• C. A common user can create a local role by default in any pluggable database (PDB) that is plugged in to a CDB.
• D. A common role can be granted only system privileges.
• E. The root container can have both local and common roles.
• F. A local role can be assigned to a common role in a PDB.

Correct answer: A, C

Explanation

The correct statements are A and C because local roles indeed can be granted to both local and common users, and common users can create local roles in any PDB by default. Options B, D, and E contain inaccuracies regarding the limitations and privileges of common roles, while option F incorrectly suggests a local role can be assigned to a common role.