Re: Views permision -- please help and suggestion

On 05/24/2011 10:04 AM, salah jubeh wrote:
> Hello Adrian,
>
> I have changed the permission of one table where view B depend on and my
> problem is over. Still; the whole issue is confusing me.

See here for explanation:
http://www.postgresql.org/docs/9.0/interactive/sql-createview.html
"Access to tables referenced in the view is determined by permissions of
the view owner. In some cases, this can be used to provide secure but
restricted access to the underlying tables. However, not all views are
secure against tampering; see Section 37.4 for details. Functions called
in the view are treated the same as if they had been called directly
from the query using the view. Therefore the user of a view must have
permissions to call all functions used by the view. "

And in turn:

http://www.postgresql.org/docs/9.0/interactive/rules-privileges.html

>
> Regards
>

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com