Re: V$ rights

From: Michel Cadot <micadot_at_netcourrier.com>
Date: Thu, 2 Sep 1999 10:10:33 +0200
Message-ID: <7qlbf1$4rn$1@oceanite.cybercable.fr>

As user sys, you can grant select on these views to your user or if you have many users, you can create a role "monitor" and grant select on the v$ views to the role et grant the role to the users.

The following script generates the grants: connect sys/...
set pagesize 0
set feedback off
spool grant
select 'grant select on '||view_name||' to <your user or role>;' from user_views where view_name like 'V_$%' order by 1
/
spool off
set feedback on
@grant.lst

David F. Newman a écrit dans le message <86hfleatdj.fsf_at_churchill.ourvillage.com>...
>
>I have an interesting problem. I have a user who's task
>it is to monitor a database's performance during a load
>test. Without granting DBA to that user, what would be
>the next best thing to allow that user to query the v$
>views?
>
>--
>David F. Newman
>Oracle DBA
>buzzwang_at_ourvillage.com
>
Received on Thu Sep 02 1999 - 03:10:33 CDT