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