Examine the commands executed in CDBS ROOT of your multitenant container database (CDB) that has
multiple pluggable databases (PDB):
SQL> CREATE ROLE c ##role1 CONTAINER-ALL;
SQL> GRANT CREATE SESSION, CREATE TABLE TO c##role1 CONTAINER’ALL;
SQL>CREATE USER c##adnin IDENTIFIED BY orcl123;
SQL>GRANT c##role1 TO c##admin CONTAINER=ALL;
SQL> GRANT SELECT ON DBA_USERS to c##rola1 CONTAINER*ALL;
Which statement is true about granting the select privilege on the DBA_users view to the c##ROLE1role?
A.
The command fails and gives an error because object privileges cannot be granted to a common user.
B.
The command fails because container is not set to current.
C.
The command succeeds and the common user cmadnxn can create a session and query the D3A_users
view in cdbssoo? and all the PDBs.
D.
The command succeeds and the common user ct (admin can create a session in cdbSroot and all the
PDBs, but can only query the dba_users view in ct3S?cdt.
E.
The command succeeds and the common user c#(admin can create a session and query the D3A users
view only in cdbsrooi.
Ans C