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

List:       postgis-users
Subject:    Re: [postgis-users] Record permission
From:       Mike Toews <mwtoews () gmail ! com>
Date:       2010-07-23 13:12:35
Message-ID: AANLkTikzQ-qfNsCwrFAFfXPi6s8pni0AtnLU_MeCCACC () mail ! gmail ! com
[Download RAW message or body]

You after something called "row level permissions". Search that term
and see some examples on how to implement it. It is possible, but it
is difficult to set up and maintain. PostgreSQL does not support it
out of the box.

Basically, you need to have a table of users, which mirrors your
pg_user system view, and the PostGIS table(s) that require row level
permissions are accessed using views with rules. The rules need to be
tuned to understand the permissions from your user table using
CURRENT_USER. I did this once as a proof of concept, but not in
production use.

-Mike

On 23 July 2010 00:10, Jaime Fiers <jaime.fiers@gmail.com> wrote:
> 
> Hi again guys.
> 
> Another question.
> 
> Is it possible to get record/line level permission.  I mean, I need some user can \
> view only records that math with some condition inside a table... another user can \
> edit some different recods... 
> I found web information, but I was no able to get it.
> 
> Thanks in advance
> 
> 
> 
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users@postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> 
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users


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