column lock?

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

column lock?

vollbotz
Hi,

is it possible to lock a column of a table?

> i edit data via qgis, but not every colum should be editable...

i there a way?

thanx V°

_______________________________________________
postgis-users mailing list
[hidden email]
https://lists.osgeo.org/mailman/listinfo/postgis-users
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: column lock?

Giuseppe Broccolo-2
Hi Volker,

2017-07-05 15:39 GMT+02:00 <[hidden email]>:
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
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
[hidden email]
https://lists.osgeo.org/mailman/listinfo/postgis-users
Loading...