Can we give v$parameter access to Normal users and How?
I have tried to give but it was giving below error.
ERROR at line 1:
ORA-02030: can only select from fixed tables/views
Printable View
Can we give v$parameter access to Normal users and How?
I have tried to give but it was giving below error.
ERROR at line 1:
ORA-02030: can only select from fixed tables/views
V$ views require DBA privileges.
But if you are not changing the init.ora file, you could run a script that creates a table with the v$parameter information that users could view.
Thanks,
So only DBA can query the v$views.
Hi,
you can aso grant the select_catalog_role so than all dictonary tables can be accessed. Also the v$parameter view.
HTH
Tycho