Re: problem permission on view

Folks,

> If the view V use a function F.
>
> In this last case is not enough have the select permisson on V but I have
> to give also the Execution permission on F!!!

As said, I discussed this with Gaetano on IRC, and am not sure why things are 
set up the way they are.    If a user has permission on a view, shouldn't 
that include permission on any functions executed by the view?    If not, why 
not?

-- 
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco