-
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.
-
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>;).
-
granting select for a V$ view
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.
-
as Oracle account sys do:
grant select on SYS.V_$DATABASE to scott;
-
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
-
Hi All those v$ tables are owned by SYS. So, login as SYS and and grant
Thanks
Kishore Kumar
-
Programatic way to grant select
Hi Kishore,
It did work.Thanks.Can we do same thing in programatic way rather than using SQL*PLUS ? Thanks.
---Radha
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|