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.
正确答案:D
答案解析:有

微信扫一扫手机做题