问题:
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
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()
● 参考解析
本题暂无解析
相关内容
相关标签