[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    Re: [postgis-users] column lock?
From:       Giuseppe Broccolo <g.broccolo.7 () gmail ! com>
Date:       2017-07-06 10:28:23
Message-ID: CAFtuf8DttkqTq6RkWt4JW2xh1G+-XeKjs=aeE1DdD0VRv5p81g () mail ! gmail ! com
[Download RAW message or body]

[Attachment #2 (multipart/alternative)]


Hi Volker,

2017-07-05 15:39 GMT+02:00 <volker.emmel@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.

[Attachment #5 (text/html)]

<div dir="ltr">Hi Volker,<br><div><div class="gmail_extra"><br><div \
class="gmail_quote">2017-07-05 15:39 GMT+02:00  <span dir="ltr">&lt;<a \
href="mailto:volker.emmel@lwk-rlp.de" \
target="_blank">volker.emmel@lwk-rlp.de</a>&gt;</span>:<br><blockquote \
class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid \
rgb(204,204,204);padding-left:1ex"><font size="2" face="sans-serif">Hi,</font> <br>
<br><font size="2" face="sans-serif">is it possible to lock a column of a
table?</font>
<br>
<br><font size="2" face="sans-serif">&gt; i edit data via qgis, but not every
colum should be editable...</font>
<br></blockquote><div><br></div><div>In PostgreSQL you can revoke permission at \
column table. This is possible<br></div><div>since (at least) the 8.4 version: <a \
href="https://www.postgresql.org/docs/8.4/static/sql-revoke.html">https://www.postgresql.org/docs/8.4/static/sql-revoke.html</a><br><br></div><div>Could \
something like this be fine for you?<br><br><pre class="gmail-SYNOPSIS">REVOKE \
INSERT, UPDATE (<tt class="gmail-REPLACEABLE gmail-c2">column</tt>1, column2, ...)  \
ON <tt class="gmail-REPLACEABLE gmail-c2">tablename</tt>  FROM \
rolename;<br><br></pre><pre class="gmail-SYNOPSIS"><span \
style="font-family:arial,helvetica,sans-serif">All the best,<br></span></pre><pre \
class="gmail-SYNOPSIS"><span \
style="font-family:arial,helvetica,sans-serif">Giuseppe.<br></span></pre> \
</div></div></div></div></div>


[Attachment #6 (text/plain)]

_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users

[prev in list] [next in list] [prev in thread] [next in thread]