Which statement is true about granting the select privilege on the DBA_users view to the c##ROLE1role?

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?

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.



Leave a Reply 12

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


MJ

MJ

Can someone test this and share the answer? This answer key is jacked.

puntano

puntano

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>

gsk

gsk

Thanks everyone for your inputs

Tri

Tri

C

Tri

Tri

C tested. However the question is terribly wrong typo.

RAVEEPAUL SINGH

RAVEEPAUL SINGH

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