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

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??? Received on Thu Apr 21 2005 - 09:09:21 CDT