Your Oracle 12c multitenant container database (CDB) contains multiple pluggable databases (PDBs). In the PDB hr_pdb, the common user c##admin and the local user b_admin have only the connect privilege.
You create a common role c##role1 with the create table and select any table privileges. You then execute the commands:
SQL> GRANTc##role1 TOcMadmin CONTAINER=ALL;
SQL> CONNsys/oracle@HR_PDB assysdba
SQL> GRANTc##role1TO b_admin CONTAINER=CURRENT;
Which two statements are true?
A.
C##admin can create and select any table, and grant the c##role1 role to users only in the root
container.
B.
B_admin can create and select any table in both the root container and kr_pdb.
C.
c##admin can create and select any table in the root container and all the PDBs.
D.
B_admin can create and select any table only in hr_pdb.
E.
The grant c=.role1 to b_admin command returns an error because container should be set to ALL.
C&D
CD
CD