Re: Select access to v_$

Barbara Hiles wrote:
>
> This is probably going to be something really dumb - but....
> I can't do selects on v_$ tables or views or whatever they are. I can access
> the same v$ stuff. And I suppose that should be good enough - but I don't
> understand why I can't get the v_$ stuff.
> I have the dba role and I also setup the monitorer role (which specifically
> grants select access to a lot of the v_$ tables) and gave that to me and I
> still get table or view doesn't exist.
> If I log in as sys I can do the select.
> What is the catch? What am I missing?

  They are dynamic performance tables but not actual table stored in the data dictionary. As a result, their behaviors are different.

-- 
Name        : Lun Wing San
Title       : Oracle developer of the Hong Kong Productivity Council
              System Administrator and Oracle DBA of the Quick Response
Center
Email Addr. : sunny_at_hkpc.org
Telephone   : 852-2788-5841