Hello Ger.
I actually asked this before from Mr. Kohei, and we had a hot debate
here I refer you to this archive:
http://marc.info/?l=selinux&m=129178180819602&w=2
Also this is original proposal of the project from Mr. KaiGai Kohei
http://sepgsql.googlecode.com/files/PGcon2010-KaiGai-LAPP_SELinux.pdf
In brief:
Since it is possible to use file labels and database locations and have
multiple instances of Postgresql as it is process based daemon, and just
separate classified and unclassified databases from each other
BUT:
the goal of Mr. KaiGai Kohei and se-postgresql project is to introduce
MLS (Multilevel Security) to the structure of the database and its ACL
model for each user of the database in example up to the rows and
columns, so in practice THEORETICALLY it would be possible to mix
classified or unclassified records within a single database and have
various levels of users with different levels of access
(however in practice it may not be recommended)
Currently with PostgreSQL it is possible to achieve this by separation
of databases and their storage location; you have to completely separate
the datases, processes and daemons accessing such resources up to
different classifications you want to serve records on an MLS systems.
Best,
Patrick K.
On 1/31/2011 5:09 AM, Ger Lawlor (gelawlor) wrote:
I'm only new to SeLinux, but will have requirements around PostgreSQL.
Can you give me some background and info on why
This SE-PostgresQL exists? Is it specific to this database, or are there
similar projects for other database types?
Was it not possible to label files within a default installation? Was
this insufficient for Postgres security?
Thanks,
Ger.
-----Original Message-----
From: owner-selinux@xxxxxxxxxxxxx [mailto:owner-selinux@xxxxxxxxxxxxx]
On Behalf Of KaiGai Kohei
Sent: Monday, January 31, 2011 8:14 AM
To: selinux@xxxxxxxxxxxxx
Subject: Tiny version of SE-PostgreSQL got merged
A few days ago, a tiny initial version of SE-PostgreSQL got merged
in the v9.1 development cycle at this commit: http://bit.ly/gF2QPQ
Although it omits various features which I planned at first, it
seems to me an ambitious first step.
PostgreSQL has shifted to provide a set of facilities to implement
label based mandatory access control, such as security label support
on database objects or security hooks being available for plug-in
modules.
The current version of SE-PostgreSQL is implemented as a plugin
module that utilizes these hooks (but only a limited places are
covered), then it asks SELinux in kernel whether the required
access shall be allowed, or not.
In the next development, I'd like to expand its access control coverage
using more fine grained security hooks. Right now, DDL permissions are
restrictions. Also, row-level security is in-progress feature.
I have much things to do for the v9.2 or v9.3, however, I'd like to
appreciate people who have given me many feedbacks since 2006
Thanks,
--
This message was distributed to subscribers of the selinux mailing list.
If you no longer wish to subscribe, send mail to majordomo@xxxxxxxxxxxxx with
the words "unsubscribe selinux" without quotes as the message.
