Hi Volker, 2017-07-05 15:39 GMT+02:00 <volker.em...@lwk-rlp.de>:
> Hi, > > is it possible to lock a column of a table? > > > i edit data via qgis, but not every colum should be editable... > In PostgreSQL you can revoke permission at column table. This is possible since (at least) the 8.4 version: https://www.postgresql.org/docs/8.4/static/sql-revoke.html Could something like this be fine for you? REVOKE INSERT, UPDATE (column1, column2, ...) ON tablename FROM rolename; All the best, Giuseppe.
_______________________________________________ postgis-users mailing list postgis-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/postgis-users
