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.HR can grant the privilege to JIM but without GRANT OPTION.B.HR can grant the privilege to JIM because HR is the owner of the view.C.SCOTT has to grant the SELECT privilege on the EMP table to JIM before this operation.D.HR needs the SELECT privilege on the EMP table with GRANT OPTION from SCOTT for this operation.

单项选择题

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.HR can grant the privilege to JIM but without GRANT OPTION.
B.HR can grant the privilege to JIM because HR is the owner of the view.
C.SCOTT has to grant the SELECT privilege on the EMP table to JIM before this operation.
D.HR needs the SELECT privilege on the EMP table with GRANT OPTION from SCOTT for this operation.

1Z0-042