Maciej Mrowiec wrote:
> I'm working on RBAC implementation over posgresql and I was wondering is
> there any common technique to
> achieve row level access control ?
>
> So far I'm considering using WITH clause in template like this:
>
> WITH AS ( SELECT . ) ;
>
> Which would be just prepe
Hello List :D
I'm working on RBAC implementation over posgresql and I was wondering is
there any common technique to achieve row level access control ?
So far I'm considering using WITH clause in template like this:
WITH AS ( SELECT . ) ;
Which would be just prepended to any specified quer
David Fetter <[EMAIL PROTECTED]> writes:
> I'm working on a way to do row-level access via VIEWs and ROLEs.
You sure you're not re-inventing the wheel?
http://pgfoundry.org/projects/veil/
regards, tom lane
---(end of broadcast)-
David Fetter wrote:
> Folks,
>
> I'm working on a way to do row-level access via VIEWs and ROLEs. The
> idea:
>
> Given a table foo with pk foo_id, which is to be the subject of these
> row-level permissions, I'd make another table, say can_read_foo, which
> looks like:
>
> CREATE TABLE can_rea
Folks,
I'm working on a way to do row-level access via VIEWs and ROLEs. The
idea:
Given a table foo with pk foo_id, which is to be the subject of these
row-level permissions, I'd make another table, say can_read_foo, which
looks like:
CREATE TABLE can_read_foo (
foo_id INTEGER NOT NULL REFE
