Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: view problems with imbedded procedure.....
steven.fox_at_dfas.mil wrote:
> I had a blond moment here.... the procedure is a package....
> one more time....
> Sorry
> Lets clearify.... the view is in one schema while the package it
> references is in another. the view schema has execute on the
> package, but when we try to grant select to the schema which owns the
> package we get an error that the package needs a execute granted
> with grant option which is frond on here...so the question is does the
> rights to execute a package follow when it is called by a view???
>
I give up
-- Frank van BortelReceived on Thu Apr 21 2005 - 14:01:52 CDT