In your multitenant container database (CDB) containing pluggable database (PDBs), you
granted the CREATE TABLE privilege to the common user C # # A_ADMIN in root and all
PDBs. You execute the following command from the root container: SQL > REVOKE create
table FROM C # # A_ADMIN; What is the result?
A.
It fails and reports an error because the CONTAINER=CURRENT clause is not used.
B.
It executes successfully and the CREATE TABLE privilege is revoked from C # #
A_ADMIN in root only.
C.
It executes successfully and the CREATE TABLE privilege is revoked from C # #
A_ADMIN in all PDBs.
D.
It fails and reports an error because the CONTAINER=ALL clause is not used.
E.
It excludes successfully and the CREATE TABLE privilege is revoked from C # #
A_ADMIN in root and all PDBs.
B
CONTAINER Clause:
If the current container is a PDB, then you can specify CONTAINER = CURRENT to change the attributes of a local user, or the container-specific attributes (such as the default tablespace) of a common user, in the current container. If the current container is the root, then you can specify CONTAINER = ALL to change the attributes of a common user across the entire CDB. If you omit this clause and the current container is a PDB, then CONTAINER = CURRENT is the default. If you omit this clause and the current container is the root, then CONTAINER = ALL is the default.
https://docs.oracle.com/database/121/SQLRF/statements_4003.htm#SQLRF01103
Restriction on Modifying Common Users in a CDB
Certain attributes of a common user must be modified for all the containers in a CDB and not for only some containers. Therefore, when you use any of the following clauses to modify a common user, ensure that you modify all of the containers by connecting to the root and specifying CONTAINER=ALL:
IDENTIFIED clause
PASSWORD clause