A database user SMITH tries to query the V$SESSION view and fails to access it as follows: SQL> connect smith/smith <br /> Connected. <br /> SQL> SELECT * FROM v$session; <br /> SELECT * FROM v$session * <br /> ERROR at line 1: <br /> ORA-00942: table or view does not exist <br /> 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