Oracle Database 12c: Advanced Administration — Question 85

You are administering a multitenant container database (CDB) cdb1 that has multiple pluggable databases (PDBs). As the sys user on cdb$root, you execute the commands:
SQL> CREATE USER C##ADMIN IDENTIFIED BY orc1123;
SQL> GRANT CREATE SESSION to C##ADMIN CONTAINER=ALL;
SQL> GRANT CREATE USER TO C##ADMIN CONTAINER=ALL;
Which two statements are true about the c##admin user that is created in all PDBs?

Answer options

• A. It can create only local users in all the PDBs.
• B. It has a common schema for all the PDBs.
• C. It can create common users only when it is logged in to the CDB.
• D. It can create only local users in the CDB.
• E. It can be granted only common roles in the PDBs.

Correct answer: A, B

Explanation

The c##admin user can create only local users in all PDBs because it was granted the CREATE USER privilege with CONTAINER=ALL, which applies to local users in each PDB. Additionally, it has a common schema across the PDBs due to the prefix 'C##', indicating that it is a common user, which is why option B is also correct. The other options are incorrect as they misinterpret the capabilities of the c##admin user.