What is the result of the revoke command?

Examine the commands executed in the root container of your multitenant container database (CDB) that has multiple pluggable databases (PDBs):

SQL> CREATE USER c##a_admin IDENTIFIED BY orcl123;

SQL> CREATE ROLE c##role1 CONTAINER=ALL;
SQL> GRANT CREATE VIEW TO C##roleI CONTAINER=ALL;
SQL> GRANT c##role1 TO c##a_admin CONTAINER=ALL; SQL> REVOKE c##role1 FROM c##a_admin;

What is the result of the revoke command?

Examine the commands executed in the root container of your multitenant container database (CDB) that has multiple pluggable databases (PDBs):

SQL> CREATE USER c##a_admin IDENTIFIED BY orcl123;

SQL> CREATE ROLE c##role1 CONTAINER=ALL;
SQL> GRANT CREATE VIEW TO C##roleI CONTAINER=ALL;
SQL> GRANT c##role1 TO c##a_admin CONTAINER=ALL; SQL> REVOKE c##role1 FROM c##a_admin;

What is the result of the revoke command?

A.
It executes successfully and the c##role1role is revoked from the c##a_admin user only in the
root container.

B.
It fails and reports an error because the container=all clause is not used.

C.
It executes successfully and the c##rocl1 role is revoked from the c##a_admin user in the root database and all the PDBs.

D.
It fails and reports an error because the comtainer=current clause is not used.



Leave a Reply 3

Your email address will not be published. Required fields are marked *


ismaelv90

ismaelv90

I think B.