I've got a PostGIS databases, with lots of schemas. I can easily create a new user that will allow them to update and delete features. However when I get the user to create a new feature I get the following error in QGIS:-
PostGIS error while adding features: ERROR: new row for relation "conservation_areas" violates check constraint "enforce_geotype_geom
I've used the following SQL to GRANT the user (anne) privilages that will allow her to update and delete, but I guess its the insert bit that is letting me down.
GRANT ALL ON SCHEMA conservation TO anne; GRANT SELECT ON ALL TABLES IN SCHEMA conservation TO anne; GRANT UPDATE ON conservation.conservation_areas_gid_seq To anne; GRANT UPDATE ON conservation.conservation_areas TO anne;
The postgres user has no such issues when edited data, therefore I'm missing something somewhere when i'm granting the user permissions. Is there a simple SQL that will allow a user to do everything that the Postgres user can do but to a specific tables (and not all tables) within a schema?