多选题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
题目
多选题
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