Examine the commands executed in CDBS ROOT of your multitenant container database
(CDB) that has multiple pluggable databases (PDB):
SQL> CREATE ROLE c ##role1 CONTAINER-ALL;
SQL> GRANT CREATE SESSION, CREATE TABLE TO c##role1 CONTAINER’ALL;
SQL>CREATE USER c##adnin IDENTIFIED BY orcl123;
SQL>GRANT c##role1 TO c##admin CONTAINER=ALL;
SQL> GRANT SELECT ON DBA_USERS to c##rola1 CONTAINER*ALL;
Which statement is true about granting the select privilege on the DBA_users view to the
c##ROLE1role?
A.
The command fails and gives an error because object privileges cannot be granted to a
common user.
B.
The command fails because container is not set to current.
C.
The command succeeds and the common user cmadnxn can create a session and query
the D3A_users view in cdbssoo? and all the PDBs.
D.
The command succeeds and the common user ct (admin can create a session in cdbSroot
and all the PDBs, but can only query the dba_users view in ct3S?cdt.
E.
The command succeeds and the common user c#(admin can create a session and query
the D3A users view only in cdbsrooi.
Can someone test this and share the answer? This answer key is jacked.
C
I agree C.
SQL> CREATE ROLE c##role1 CONTAINER=ALL;
GRANT CREATE SESSION, CREATE TABLE TO c##role1 CONTAINER=ALL;
CREATE USER c##adnin IDENTIFIED BY orcl123;
GRANT c##role1 TO c##admin CONTAINER=ALL;
GRANT SELECT ON DBA_USERS to c##role1 CONTAINER=ALL;
Role created.
SQL>
Grant succeeded.
SQL> CREATE USER c##admin IDENTIFIED BY orcl123
Grant succeeded.
SQL>
Grant succeeded.
SQL>
Grant succeeded.
SQL>
Thanks everyone for your inputs
C
C
C tested. However the question is terribly wrong typo.
C
C
C
hi
guys i attempt izo-067 on 13-march-2017 but failed scored just 46% this questions are not enough i have got some questions from izo-060 as well and some question were there but the answers were totally changed its very tricky if someone attempted and through the exam kindly let me know please
C