Skip site navigation (1) Skip section navigation (2)

Re: Updates of SE-PostgreSQL 8.4devel patches

From: KaiGai Kohei <kaigai(at)ak(dot)jp(dot)nec(dot)com>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: Peter Eisentraut <peter_e(at)gmx(dot)net>, KaiGai Kohei <kaigai(at)kaigai(dot)gr(dot)jp>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Andrew Sullivan <ajs(at)commandprompt(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Updates of SE-PostgreSQL 8.4devel patches
Date: 2008-09-30 01:19:21
Message-ID: 48E17E99.3060204@ak.jp.nec.com (view raw or flat)
Thread:
Lists: pgsql-hackers
Bruce Momjian wrote:
> I think there are two goals here.  At the SQL-level, we will have
> per-role row and column permissions (which seem valuable on their own),
> and SE-PostgreSQL allows those permissions to be controlled at the
> operating system level rather than at the database level.

Yes, it is correct.
As someone noted, SQL-level fine-grained access controls are also usefull
feature. I understand it.
SE-PostgreSQL makes its decision based on the security policy stored
in operating system because of the "consistency". However, database objects
are invisible for operating system, so we have to add an option to RDBMS.

> I think your major question is how often do you have users that you need
> to control at both the SQL _and_ operating system level.  I guess the
> answer is that security policy suggests controlling things at the lowest
> level, and bubling that security up into the database and applications.

As I mentioned at the previous message, it is very frequent case when
a single web application accesses both filesystem objects and database
objects at the same time.
The important thing is to turn off at the main. Smaller number of security
sensitive codes are betther for consistency and completeness in security.

Thanks,
-- 
OSS Platform Development Division, NEC
KaiGai Kohei <kaigai(at)ak(dot)jp(dot)nec(dot)com>

In response to

pgsql-hackers by date

Next:From: KaiGai KoheiDate: 2008-09-30 01:28:02
Subject: Re: Updates of SE-PostgreSQL 8.4devel patches
Previous:From: KaiGai KoheiDate: 2008-09-30 01:06:02
Subject: Re: Updates of SE-PostgreSQL 8.4devel patches

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group