Which three statements are true about common roles?
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.
ADE
Both system and object privileges can be commonly granted
CDE
A is wrong because the common role can be granted to local users
SQL> sho user
USER is “C##U”
SQL> grant C##R to local_pdb1;
Grant succeeded.
SQL> sho con_name
CON_NAME
——————————
PDB1
CDE
A is wrong due to word “only”
common roles can be granted to common users to.
You must be carefull with words “only” and “allways” which most of the times can make you fail the question
Thank you CDE are correct answers
CDE