Examine the commands executed in CDB$ROOT of your multitenant container database (CDB) that has multiple pluggable databases (PDB):
Which statement is true about granting the select privilege on the DBA_users view to the c##ROLE1 role?
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 c##admin can create a session and query the DBA_users view in cdb$root and all the PDBs.
D.
The command succeeds and the common user c##admin can create a session in cdb$root and all the PDBs, but can only query the dba_users view in cdb$root.
E.
The command succeeds and the common user c##admin can create a session and query the DBA_users view only in cdb$root.