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

Pietro Rossin pietro.rossin at arpa.fvg.it
Wed May 18 01:45:20 PDT 2016

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?

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.

More information about the postgis-users mailing list