Skip to contentSkip to conversation

database administrator domain

PATCH New KaiGai Kohei 2 participants 2 messages Dec 4, 2009 – Feb 9, 2010

lore
Share & tools
lore
#0 lore raw

PATCH 1/1 database administrator domain

The attached patch add a new role for database administrator (dbadm). Most of postgresql_admin() definitions were copied from Dan's patch, so either of them may conflict, but it is not difficult to integrate.

- It allows dbadm to start/stop PostgreSQL server process, and to manage corresponding files.

- It allows dbadm to start/stop MySQL server process, and to manage corresponding files.
(*) Note that I've not tested MySQL related permissions yet.

- It allows to execute su and sudo to run init script.

- It allows to execute DDL statements in SE-PostgreSQL, but permissions to execute DML statement are depending on the sepgsql_unconfined_dbadm boolean.
It allows to control whether user data are visible for DBA, or not. (Oracle's security option has similar idea. All the DBA can do is
defining the schema, not available to access user data.)

- postgresql_role() is moved to unprivuser.te, staff.te and webadm.te from the userdom_unpriv_user_template(), because different rules should be applied on dbadm role.

----
BTW, I have a plan to define an individual domain for backup and restore utilities to separate permissions to access user data from dbadm role in the future.
In this situation, dbadm can execute backup/restore utilities which can access user data with domain transition, but dbadm cannot access user data directly in database and newly generated backup file. It ensures DBA to dump whole of the database with keeping confidence of the contents.

See the page.28 in:
http://sepgsql.googlecode.com/files/JLS2009-KaiGai-LAPP_SELinux.pdf

Thanks,

Signature · 9 lines
OSS Platform Development Division, NEC
KaiGai Kohei <[email protected]>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: refpolicy-dbadm.patch
Type: text/x-patch
Size: 10282 bytes
Desc: not available
Url : http://oss.tresys.com/pipermail/refpolicy/attachments/20091204/47c7a17e/attachment.bin 
#1 lore raw

PATCH 1/1 database administrator domain

Quoted 20 lines · KaiGai Kohei

The attached patch add a new role for database administrator (dbadm). Most of postgresql_admin() definitions were copied from Dan's patch, so either of them may conflict, but it is not difficult to integrate.

- It allows dbadm to start/stop PostgreSQL server process, and to manage corresponding files.

- It allows dbadm to start/stop MySQL server process, and to manage corresponding files.
(*) Note that I've not tested MySQL related permissions yet.

- It allows to execute su and sudo to run init script.

- It allows to execute DDL statements in SE-PostgreSQL, but permissions to execute DML statement are depending on the sepgsql_unconfined_dbadm boolean.
It allows to control whether user data are visible for DBA, or not. (Oracle's security option has similar idea. All the DBA can do is
defining the schema, not available to access user data.)

Quoted 3 lines

- postgresql_role() is moved to unprivuser.te, staff.te and webadm.te from the userdom_unpriv_user_template(), because different rules should be applied on dbadm role.

Merged.

Signature · 3 lines
Chris PeBenito
Tresys Technology, LLC
(410) 290-1411 x150