[askdba] Re: hw to grant on DBA_ and v$ views?

  • From: Ganesh Raja <ganesh.raja@xxxxxxxxx>
  • To: askdba@xxxxxxxxxxxxx
  • Date: Tue, 25 Jan 2005 17:33:06 +0000

Select Any Catalogue Role is the Way to Go . From 9i the Select Any
Table privs will not give u acess to the V$ Views ..

HTH

Cheers
Ganesh


On Tue, 25 Jan 2005 22:58:23 +0530, Chirag DBA <chiragdba@xxxxxxxxx> wrote:
> Hi Friends..!!
> 
> How to grant select to a user on DBA_ and V$ views?
> 
> Grant Select any table to USER1; will do that?
> or I need to give select any catalogue role?
> 
>

Other related posts: