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?
A.
It is created only in cdb$root and cannot be granted to the c##admin user with the container=all
clause.
B.
It is granted to the c##admin user only in the CDB.
C.
It is granted to the c##admin user in all PDBs and can be granted only to a local user in a PDB.
D.
It is granted to the c##admin user in all PDBs and can be granted object and system privileges for a PDB.
Explanation:
B
B
I think D.
I think C
the question is not right. If asking what happens to the privileges, then Answer should be B.
D