Mercurial > gemma
comparison .hgignore @ 4616:b605e91f08f0 geoserver_sql_views
Use GeoServer's SQL view feature instead of in-database VIEWs
VIEWs are executed with the rigths of their owner, but we need to
access the data with the rights of the current_user in order to
have row level security policies applied correctly. Moving the
former VIEW definitions into GeoServer SQL views achieves this, as
the latter are executed as subqueries in usual statements.
Note that a fresh GeoServer setup is required to make this work,
which can be achieved e.g. by starting gemma with the
geoserver-clean flag. Otherwise, GeoServer will keep trying to
access the dropped VIEWs.
author | Tom Gottfried <tom@intevation.de> |
---|---|
date | Tue, 10 Sep 2019 19:56:43 +0200 |
parents | e53ff5bcc020 |
children | 1ab8a5bbce02 |
comparison
equal
deleted
inserted
replaced
4615:32d3e0cecf4f | 4616:b605e91f08f0 |
---|