Re: How to get SE-PostgreSQL acceptable - Mailing list pgsql-hackers

From Tom Lane
Subject Re: How to get SE-PostgreSQL acceptable
Date
Msg-id 21136.1233171516@sss.pgh.pa.us
Whole thread Raw
In response to Re: How to get SE-PostgreSQL acceptable  (Gregory Stark <stark@enterprisedb.com>)
Responses Re: How to get SE-PostgreSQL acceptable  (Bruce Momjian <bruce@momjian.us>)
Re: How to get SE-PostgreSQL acceptable  (Zeugswetter Andreas OSB sIT <Andreas.Zeugswetter@s-itsolutions.at>)
List pgsql-hackers
Gregory Stark <stark@enterprisedb.com> writes:
> I don't think partitioning is really the same thing as row-level
> security.

Of course not, but it seems to me that it can be used to accomplish most
of the same practical use-cases.  The main gripe about doing it via
partitioning is that the user's nose gets rubbed in the fact that there
can't be an enormous number of different security classifications in the
same table (since he has to explicitly make a partition for each one).
But the proposed implementation of row-level security would poop out
pretty darn quick for such a case, too, and frankly I'm not seeing an
application that would demand it.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Mark Cave-Ayland
Date:
Subject: Re: mingw check hung
Next
From: Heikki Linnakangas
Date:
Subject: Re: Hot Standby (v9d)