A database user SMITH tries to query the V$SESSION view and fails to access it as follows:
Which are the two possible solutions to enable SMITH to query the data in V$SESSION? (Choose
two.)
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
I think “E” is correct and not “F”
Sorry, F is correct… I think that E is correct for all users of the database and not only for the user SCOTT.
Letter B and letter F.