试题详情
多项选择题 A database user SMITH tries to query the V$SESSION view and fails to access it as follows： SQL> connect smith/smith  Connected.  SQL> SELECT * FROM v$session；  SELECT * FROM v$session *  ERROR at line 1：  ORA-00942： table or view does not exist  Which are the two possible solutions to enable SMITH to query the data in V$SESSION（）

A、granting SELECT privilege to SMITH on V$SESSION

B、granting SELECT privilege to SMITH on V_$SESSION

C、asking the user SMITH to run the catalog.sql script

D、granting SELECT privilege to SMITH on V$FIXED_TABLES

E、setting the O7_DICTIONARY_ACCESSIBILITY parameter to TRUE

F、creating a view based on V$SESSION and granting SELECT privilege to SMITH on the view that was created

  • B,F

  • 关注下方微信公众号，在线模考后查看

热门试题