I have a PostgreSQL database, and only with the PostgreSQL user (who's the owner of that table), I'm able to save styles to the database. I checked the user's permissions for the other group roles and all have SELECT, INSERT, UPDATE, and DELETE privileges over the layer styles table. So I really don't understand why they can't save the styles.

The group that I have is called r_readwrite and has USAGE in all schemas on the database and only SELECT, INSERT, UPDATE and DELETE privileges in a couple of tables (one of them the layer_styles). The other group that I have is called r_readonly and only has SELECT privileges over all tables in the database.

those are the privileges

Does the group need to be set as the owner of the table to add styles? Maybe I'm missing something because once I changed the owner of the table from postgres to the group role it worked.



Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.