Re: Whose privileges are missing?

From: Robert Wagner <RobertWagner_at_alum.mit.edu>
Date: 2000/06/08
Message-ID: <4AS%4.2184$9E6.23112@newsr1.maine.rr.com>#1/1

After some help via email from Marc Melançon <mmelanco_at_sfi-software.com>, and reading a bit more in Feuerstein et al's "Oracle Built-In Packages" (p.48), I realized that RWDEVELOPER did not have CREATE VIEW privileges. That solved the problem. I was confused because RWDEVELOPER _COULD_ create the view directly without that privilege. That's because RWDEVELOPER also had the basic ROLE CONNECT, which includes the CREATE VIEW privilege (but obviously not from within functions).Out of curiosity, I'd love to know why the difference, but at least I have a solution!

Any further insights would still be welcome.

Thanks >>>>>>>>>> Robert

<jeanch_at_my-deja.com> wrote in message news:8hnn07$hrt$1_at_nnrp1.deja.com...
> I suggest you grant to the user from which the packages are installed
> the privilege to create a views. That's all I can see
>
> Cheers
> JC
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu Jun 08 2000 - 00:00:00 CDT