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.
In your multitenant container database (CDB) containing pluggable database (PDBs), you granted the CREATE TABLE privileg
-
- Site Admin
- Posts: 899559
- Joined: Mon Aug 02, 2021 8:13 am