Hi,
I organized my postgis database using schema. All users can read all
data but they can only edit there own tables. If one user save his style
into the postgres database, its creates the layer_style file in his own
schema. It is not possible for other users of this database to load this
style, if they want to view the data of this user.
QGIS uses this sql query:
SELECT styleQML FROM layer_styles WHERE
f_table_catalog='regionalplanung' AND f_table_schema='rpg_abw' AND
f_table_name='punkt_darstellung_l2' AND f_geometry_column='the_geom'
But this query fails, because the layer_styles table is located in
schema 'rpg_abw', the "home" directory of this user.
It is possible, to change the query to SELECT styleQML FROM
schema.layer_styles WHERE....?
I use QGIS 2.12.
greetings, Holger
_______________________________________________
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
