Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: view problems with imbedded procedure.....

Re: view problems with imbedded procedure.....

From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Thu, 21 Apr 2005 21:01:52 +0200
Message-ID: <d48t40$ki2$1@news1.zwoll1.ov.home.nl>


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 Bortel
Received on Thu Apr 21 2005 - 14:01:52 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US