steven.fox_at_dfas.mil wrote:
> Sorry
> Lets clearify.... the view is in one schema while the procedure it
> references is in another. the view schema has execute on the
> procedure, but when we try to grant select to the schema which owns the
> procedure we get an error that the procedure needs a execute granted
> with grant option which is frond on here...so the question is does the
> rights to execute a procedure follow when it is called by a view???
>
Steven,
which part of "you can't use a procedure in a view" did you not
understand?
Sybrand is right - but don't take our word for it!
Read it in The Fine Manual at http://tahiti.oracle.com
--
Regards,
Frank van Bortel
Received on Thu Apr 21 2005 - 09:44:00 CDT
