Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 5AC62633529 for ; Sat, 12 Dec 2009 16:30:12 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 28517-02 for ; Sat, 12 Dec 2009 20:30:04 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from tamriel.snowman.net (tamriel.snowman.net [72.66.115.51]) by mail.postgresql.org (Postfix) with ESMTP id 728866333BA for ; Sat, 12 Dec 2009 16:30:04 -0400 (AST) Received: by tamriel.snowman.net (Postfix, from userid 1000) id 63F0022943; Sat, 12 Dec 2009 15:30:03 -0500 (EST) Date: Sat, 12 Dec 2009 15:30:03 -0500 From: Stephen Frost To: pgsql-hackers Subject: Row-Level Security Message-ID: <20091212203003.GL17756@tamriel.snowman.net> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="LY1NsoLvzY7ULKdc" Content-Disposition: inline X-Editor: Vim http://www.vim.org/ X-Info: http://www.snowman.net X-Operating-System: Linux/2.6.26-1-amd64 (x86_64) X-Uptime: 14:35:35 up 107 days, 7:00, 18 users, load average: 0.03, 0.09, 0.05 User-Agent: Mutt/1.5.18 (2008-05-17) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.599 tagged_above=-10 required=5 tests=BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 200912/1093 X-Sequence-Number: 151796 --LY1NsoLvzY7ULKdc Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable Greetings, > I'll start a new thread on this specific topic to hopefully pull out > anyone who's focus is more on that than on SEPG. Row-Level security has been implemented in a number of existing commercial databases. There exists an implementation of row-level security for PostgreSQL today in the form of SEPostgres. I believe there is a signfigant user base who would like RLS without SELinux (or perhaps with some other security manager). As it is a useful feature indepenent of SELinux, it should be implemented in a way which doesn't depend on SELinux in any way. I've started a wiki page to discuss this here: http://wiki.postgresql.org/wiki/RLS I'd like to start a discussion about RLS for PG- design, user-interface, syntax, capabilities, on-disk format changes, etc. For starters, I think we shoud review the existing RLS implementations. To that end, I've added a number of articles about them to the wiki. I think the next step is to start summarizing how those operate and important similarities and differences between them. Our goal, of course, is to take the best of what's out there. Please comment, update the wiki, let us know you're interested in this..=20 Thanks! Stephen --LY1NsoLvzY7ULKdc Content-Type: application/pgp-signature; name="signature.asc" Content-Description: Digital signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (GNU/Linux) iEYEARECAAYFAksj/UsACgkQrzgMPqB3kihiugCfbNxOalho24WIdHr26fabUkTL +c0AnipscmS4euo76SWb3/BzRrn4IWrd =WELk -----END PGP SIGNATURE----- --LY1NsoLvzY7ULKdc--