The HR user creates a view with this command:
SQL> CREATE VIEW emp_v AS SELECT * FROM scott.emp;
Now HR wants to grant the SELECT privilege on the EMP_V view to the JIM user. Which
statement is true in this scenario?
A.
SCOTT has to grant the SELECT privilege on the EMP table to JIM before this operation.
B.
HR can grant the privilege to JIM but without GRANT OPTION.
C.
HR can grant the privilege to JIM because HR is the owner of the view.
D.
HR needs the SELECT privilege on the EMP table with GRANT OPTION from SCOTT for this
operation.