Re: Whose privileges are missing?

The answer to this is roles are *NOT* enabled during stored procedure execution (and compilation). In Oracle 8i you can circumvent this problem by either running the procedure with invokers rights, prior to 8i you have to grant the privilege to the user directly.

Hth,

Sybrand Bakker, Oracle DBA

Robert Wagner <RobertWagner_at_alum.mit.edu> schreef in berichtnieuws 4AS%4.2184$9E6.23112_at_newsr1.maine.rr.com...
> 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