Which statement is true about granting the select privilege on the DBA_users view to the c##ROLE1 role?

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 cdbSroot.

Download Printable PDF. VALID exam to help you PASS.

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.