Re: Newbie Oracle DBA question - Why CREATE ANY VIEW not shown
From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 31 Jul 2008 17:20:02 -0700
Message-ID: <1217549995.357549@bubbleator.drizzle.com>
>
> 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
Date: Thu, 31 Jul 2008 17:20:02 -0700
Message-ID: <1217549995.357549@bubbleator.drizzle.com>
Richard wrote:
> 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
Go to Morgan's Library at www.psoug.org and look up:
OBJECT PRIVILEGES
and
SYSTEM PRIVILEGES
The SQL statements you need are there.
-- Daniel A. Morgan Oracle Ace Director & Instructor University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Thu Jul 31 2008 - 19:20:02 CDT