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 executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in root only.
B.
It fails and reports an error because the CONTAINER=ALL clause is not used.
C.
It excludes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in root and all
PDBs.
D.
It fails and reports an error because the CONTAINER=CURRENT clause is not used.
E.
It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in all PDBs.
Explanation:
SQL> create user c##admin identified by stipsi container=all;
User created.
SQL> grant create table to c##admin container=all;
Grant succeeded.
SQL> revoke create table from c##admin;
revoke create table from c##admin
*
ERROR at line 1:
ORA-65092: system privilege granted with a different scope to ‘C##ADMIN’
Oracle Database SQL Language Reference 12c, Revoke