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()
- Agranting SELECT privilege to SMITH on V$SESSION
- Bgranting SELECT privilege to SMITH on V_$SESSION
- Casking the user SMITH to run the catalog.sql script
- Dgranting SELECT privilege to SMITH on V$FIXED_TABLES
- Esetting the O7_DICTIONARY_ACCESSIBILITY parameter to TRUE
- Fcreating a view based on V$SESSION and granting SELECT privilege to SMITH on the view that was created