Re: SE-PgSQL developer documentation (Re: Reworks for Access Control facilities (r2363)) - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: SE-PgSQL developer documentation (Re: Reworks for Access Control facilities (r2363))
Date
Msg-id 20091028132746.GC5018@alvh.no-ip.org
Whole thread Raw
In response to Re: SE-PgSQL developer documentation (Re: Reworks for Access Control facilities (r2363))  (KaiGai Kohei <kaigai@ak.jp.nec.com>)
Responses Re: SE-PgSQL developer documentation (Re: Reworks for Access Control facilities (r2363))
List pgsql-hackers
KaiGai Kohei escribió:

> There are two cases when we create a new object.
> 
> 1) create a new object without any explicit security context.
> If we don't have statement support, it is the only case.
> In this case, SELinux computes a default security context to be assigned
> on the new object. It depends on the client's security context.
> Then, it checks "create" permission on a pair of the client's security
> context and the default security context. If not allowed, an error will
> be raised.

So, following this path, it is possible to write pg_dump support without
a explicit security contexts: you have to make pg_dump write out the
different tuples under different users.  So you'd have more than one
data object in the dump output for each table, one for every existing
security context.  This seems extremely difficult and intrusive however.

It seems that having explicit security contexts in statements is
necessary for this area to be reasonably simple.

Now, let's assume that COPY data includes the security context for each
tuple in the output.  How is that data restored?  Would you need to
grant super-SEPostgres privileges to the user restoring the data?

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support


pgsql-hackers by date:

Previous
From: KaiGai Kohei
Date:
Subject: Re: SE-PgSQL developer documentation (Re: Reworks for Access Control facilities (r2363))
Next
From: Tom Lane
Date:
Subject: Re: Where's the docs?