---

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

---

出自：Oracle认证

显示答案