[postgis-users] column lock?

Giuseppe Broccolo g.broccolo.7 at gmail.com
Thu Jul 6 03:28:23 PDT 2017

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:

Could something like this be fine for you?

REVOKE INSERT, UPDATE (column1, column2, ...)
    ON tablename
    FROM rolename;

All the best,

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20170706/9dc1bbb8/attachment.html>

More information about the postgis-users mailing list