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
答案解析:有
微信扫一扫手机做题