[postgis-users] column lock?

[Giuseppe Broccolo]

Hi Volker,

2017-07-05 15:39 GMT+02:00 <volker.emmel at 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20170706/9dc1bbb8/attachment.html>