You are administering a multitenant container database (CDB) that contains multiple pluggable databases (PDBs). You are connected to cdb$root as the sys user. You execute the commands: SQL CREATE USER C##ADMIN IDENTIFIED BY orcll23; SQL CREATE ROLE C##CONNECT; SQL GRANT CREATE SESSION, CREATE TABLE, SELECT ANY TABLE TO C##CONNECT; SQL GRANT C##CONNECT to C##ADMIN CONTAINER=ALL; Which statement is true about the c##connect role?

Question

You are administering a multitenant container database (CDB) that contains multiple pluggable databases (PDBs). You are connected to cdb$root as the sys user. You execute the commands: SQL> CREATE USER C##ADMIN IDENTIFIED BY orcll23; SQL> CREATE ROLE C##CONNECT; SQL> GRANT CREATE SESSION, CREATE TABLE, SELECT ANY TABLE TO C##CONNECT; SQL> GRANT C##CONNECT to C##ADMIN CONTAINER=ALL; Which statement is true about the c##connect role?

Accepted Answer

C. It is granted to the c##admin user in all PDBs and can be granted only to a local user in a PDB.

Answer

A. It is created only in cdb$root and cannot be granted to the c##admin user with the container=all

Answer

B. It is granted to the c##admin user only in the CDB.

Answer

D. It is granted to the c##admin user in all PDBs and can be granted object and system privileges

You are administering a multitenant container database (CDB) that contains multiple pluggable databases (PDBs). You are connected to cdb$root as the sys user. You execute the commands: SQL> CREATE…

Question

Options

How the community answered

Community Discussion