[postgis-users] Query/View permission deny - strange behaviour

[Pietro Rossin]

Sorry for my poor thecnical language
Select for me is execute the view..

Yesterday I found a solution

I thought the user (or the group role he is granted to) that execute the
view must be granted to select the tables in the view.

Instead the owner of the view must be granted to select tables from where
data come....

So in this particular case sitarpa_catasto_scarichi_admins must have select
privileges on basi_amministrative.comuni_fvg_2014_3004....

This wasn't obvious to me...

Sounds good?
Thanks
Pietro





--
View this message in context: http://postgis.17.x6.nabble.com/Query-View-permission-deny-strange-behaviour-tp5010068p5010084.html
Sent from the PostGIS - User mailing list archive at Nabble.com.