Good Morning!
>From the documentation
https://docs.geoserver.org/stable/en/user/data/database/sqlview.html it is
obvious that a layer based on a SQL-View is read only.
Therefore I created an editable view directly in Postgres and registered it
as a normal layer in Geoserver. Unfortunately I still get the following
error message:
2021-02-04 06:43:50,104 ERROR [geoserver.ows] -
org.geoserver.wfs.WFSTransactionException: {mist}update_my_media_objects is
read-only
at org.geoserver.wfs.Transaction.execute(Transaction.java:241)
at org.geoserver.wfs.Transaction.transaction(Transaction.java:93)
at
org.geoserver.wfs.DefaultWebFeatureService.transaction(DefaultWebFeatureService.java:147)
Is there any workaround? I want to achieve that a user can only edit his
own records in GeoServer. Therefore I filter in the view for the logged in
user:
create or replace view update_my_media_objects as select * from
media_objects where owner_uid = current_setting('current.user', TRUE);
Thanks and all the best,
Michael
_______________________________________________
Geoserver-users mailing list
Please make sure you read the following two resources before posting to this
list:
- Earning your support instead of buying it, but Ian Turton:
http://www.ianturton.com/talks/foss4g.html#/
- The GeoServer user list posting guidelines:
http://geoserver.org/comm/userlist-guidelines.html
If you want to request a feature or an improvement, also see this:
https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
