多做题,通过考试没问题!

Oracle认证考试

睦霖题库>其他计算机考试>Oracle认证考试

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
答案解析:
进入题库查看解析

微信扫一扫手机做题