Re: Access to v$views

Doug Cowles wrote on 15-Jul-99 17:59:08:
>How do I give a developer access to all
>of the v$views?

>- Dc.

There are several possibilities:

1. Give him 'select any table' (this is most likly far to much)
2. Do something like

   select 'grant select on '||table_name||' to <user_name>;'    from dictionary where table_name like 'V$%';

   Spool that to a file and execute it.

3. Create a role and grant the select privileges to that role the way

   described in 2.
   Then grant the role to the developer.

The third method is the preferred since you can easily gran and revoke the role to other developers without having to fiddle around with any single view. Beware the you cannot use roles in PL/SQL so you have to grant the privileges directly to the user. (This is definitively true for V7 and I think for V8 too. If it is true for 8i too, I don't know.)

Hope that helps,
Lothar

--

Lothar Armbrüster       | lothar.armbruester_at_rheingau.netsurf.de
Hauptstr. 26            | lothar.armbruester_at_t-online.de
D-65346 Eltville        |