How all users access V$ Views ?

[rsonnathi]

only the sys user can execute SELECTs from the
V$ views and X$ tables.how to grant other database users access to the specific V$ views or X$ tables ?Any help would be appreciated.

[shwa]

The sys user and users granted the dba role or the select_catalog_role role can see the dynamic views. To be able to 'execute' a select (plsql?) you'll need to grant dml privs directly to a user (as sys: grant select on v$_session to <user>;).

[rsonnathi]

Shwa,

I connected as system/manager and I want to grant select on v$database to user scott how would I do ? Is it something like
grant select on v$database to system.scott ? I tried without system also.But giving an error saying table or view doesn't exist.

[sysdba]

as Oracle account sys do:
grant select on SYS.V_$DATABASE to scott;

[sambavan]

it would be


GRANT SELECT ON SYS.V_$DATABASE to scott.
You have to be a sys or a dba to grant this access.

Good luck.
Sam

[Kishore]

Hi All those v$ tables are owned by SYS. So, login as SYS and and grant

[rsonnathi]

Hi Kishore,

It did work.Thanks.Can we do same thing in programatic way rather than using SQL*PLUS ? Thanks.

---Radha

[sambavan]

Most of the time it would be better to go manually and do the grant to avoid the security breaches. One of the way you could do it is write a shell script that would first set the env to point to the database and connect as internal and then run the grant and other DDL commands that you want and exit.

Sam