Re: problem permission on view - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: problem permission on view
Date
Msg-id 200409161525.08013.josh@agliodbs.com
Whole thread Raw
In response to problem permission on view  (Gaetano Mendola <mendola@bigfoot.com>)
Responses Re: problem permission on view  (Greg Stark <gsstark@mit.edu>)
Re: problem permission on view  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Gaetano Mendola
Date:
Subject: problem permission on view
Next
From: Gavin Sherry
Date:
Subject: Re: subtransaction assert failure