Re: Newbie Oracle DBA question - Why CREATE ANY VIEW not shown

On Jul 30, 5:49 am, gazzag <gar..._at_jamms.org> wrote:
> On 30 Jul, 03:20, Richard <RSL..._at_gmail.com> wrote:
>
>
>
> > Help ?
>
> I don't have a 9.2.0.8 system to test on, I'm afraid.  But I have a
> couple of questions:
>
> 1.  What is the actual issue here?  There are other ways of finding
> the information you require without using DBMS_METADATA.
>
> 2.  Is an upgrade to 10.2.0.x out of the question?
>
> HTH
>
> -g

Is there another way to see what privilleges have been granted ? I am afraid if I dont check it run system turns over to users it will not work because of privilleges.

Thank you in advance. --Richard Received on Thu Jul 31 2008 - 12:06:42 CDT