Re: Row-Level Security - Mailing list pgsql-hackers

From Stephen Frost
Subject Re: Row-Level Security
Date
Msg-id 20091214134714.GS17756@tamriel.snowman.net
Whole thread Raw
In response to Re: Row-Level Security  (KaiGai Kohei <kaigai@kaigai.gr.jp>)
Responses Re: Row-Level Security  (KaiGai Kohei <kaigai@ak.jp.nec.com>)
List pgsql-hackers
KaiGai,

* KaiGai Kohei (kaigai@kaigai.gr.jp) wrote:
> The reason why I put on the security hook in ExecScan() is to avoid the
> problem that row-cost user defined function can be evaluated earlier
> than row-level security policy. (I believed it was a well-known problem
> at that time yet.) So, I didn't want to append it before optimization.

This is a problem which needs to be addressed and fixed independently.

> I also believe this matter should be resolved when we provide row-level
> security stuff, because it is a security feature.

This issue should be fixed first, not as part of some large-scale patch.

If you have thoughts or ideas about how to address this problem as it
relates to views, I think you would find alot of people willing to
listen and to discuss it.  This must be independent of SELinux,
independent of row-level security, and isn't something based on any of
the patches which have been submitted so far.  None of them that I've
seen resolve this problem in a way that the community is willing to
accept.
Thanks,
    Stephen

pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Adding support for SE-Linux security
Next
From: Fred Janon
Date:
Subject: pgAdmin III: timestamp displayed in what time zone?