In your multitenant container database (CDB) containing same pluggable databases
(PDBs), you execute the following commands in the root container: Which two statements
are true?
A.
The statement for granting a role to a user fails because the CONTAINER clause is not
used.
B.
Privileges are granted to the C##A_ADMIN user in the root database and all PDBs.
C.
The C # # ROLE1 role is created only in the root database because the container clause
is not used.
D.
The C # # ROLE1 role is created in the root database and all the PDBs.
E.
Privileges are granted to the C##A_ADMIN user only in the root database.
DE
agree, DE
https://oracle-base.com/articles/12c/multitenant-manage-users-and-privileges-for-cdb-and-pdb-12cr1
As demonstrated here, D is correct as the common role will be created in the root and all current/future PDBs
E is also correct. A GRANT in the root database does not get the default of “CONTAINER=ALL”. Without this addition, the GRANT will only apply to the local DB which is the root.
Tested myself and can confirm that D and E are correct.