Which are the two possible solutions to enable SMITH to query the data in V$SESSION?

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 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



Leave a Reply 3

Your email address will not be published. Required fields are marked *


Helcio

Helcio

I think “E” is correct and not “F”

Helcio

Helcio

Sorry, F is correct… I think that E is correct for all users of the database and not only for the user SCOTT.

David Vela

David Vela

Letter B and letter F.