1Z0-067 · Question #120
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>…
The correct answer is B. It fails and reports an error because the container=all clause is not used. SQL> REVOKE c##role1 FROM c##a_admin; REVOKE c##role1 FROM c##a_admin ERROR at line 1: ORA-01951: ROLE 'C##ROLE1' not granted to 'C##A_ADMIN' SQL> REVOKE c##role1 FROM c##a_admin CONTAINER=ALL; Revoke succeeded. This CREATE USER c##a_admin IDENTIFIED BY orcl123; will create…
Question
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?
Options
- AIt executes successfully and the c##role1 role is revoked from the c##a_admin user only in the
- BIt fails and reports an error because the container=all clause is not used.
- CIt executes successfully and the c##rocl1role is revoked from the c##a_adminuser in the root
- DIt fails and reports an error because the comtainer=currentclause is not used.
How the community answered
(38 responses)- A5% (2)
- B82% (31)
- C11% (4)
- D3% (1)
Explanation
SQL> REVOKE c##role1 FROM c##a_admin; REVOKE c##role1 FROM c##a_admin ERROR at line 1: ORA-01951: ROLE 'C##ROLE1' not granted to 'C##A_ADMIN' SQL> REVOKE c##role1 FROM c##a_admin CONTAINER=ALL; Revoke succeeded. This CREATE USER c##a_admin IDENTIFIED BY orcl123; will create common user event container is not specified.
Topics
Community Discussion
No community discussion yet for this question.