View the Exhibit and examine the privileges granted to the SL_REP user.
The EMP table is owned by the SCOTT user. The SL_REP user executes the following command:
SQL> GRANT SELECT ON scott.emp TO hr;
Which statement describes the outcome of the command?
A.
The command executes successfully
B.
The command produces an error because SL_REP has the GRANT ANY OBJECT PRIVILEGE without ADMIN_OPTION
C.
The command produces an error because the EMP table is owned by SCOTT
D.
The command produces an error because SL_REP does not have the SELECT privilege with GRANT_OPTION on the EMP table
Any one can explain why A is correct? I think D is correct.
I know why. “gran any object privilege”.
i think Option D
A is true and very easy to understand..
It has grant any object privilege , so it can assign select access to any table anfd to any user . .
by refereing Admin option as no it will e able to give the grant any object privilege to second/third…
A is true and very easy to understand..
It has grant any object privilege , so it can assign select access to any table anfd to any user . .
by refereing Admin option as no it will not be able to give the grant any object privilege to second/third…user