Gecko [ 122.154.134.11 ]

Name	Size	Permission
abrt.if	8.77 KB	-rw-r--r--
afs.if	2.07 KB	-rw-r--r--
aiccu.if	2.33 KB	-rw-r--r--
aide.if	1.29 KB	-rw-r--r--
aisexec.if	2.69 KB	-rw-r--r--
amavis.if	5.87 KB	-rw-r--r--
antivirus.if	6.23 KB	-rw-r--r--
apache.if	37.34 KB	-rw-r--r--
apcupsd.if	3.45 KB	-rw-r--r--
apm.if	2.04 KB	-rw-r--r--
arpwatch.if	3.09 KB	-rw-r--r--
asterisk.if	2.02 KB	-rw-r--r--
audioentropy.if	56 B	-rw-r--r--
automount.if	3.83 KB	-rw-r--r--
avahi.if	3.21 KB	-rw-r--r--
bacula.if	2.44 KB	-rw-r--r--
bcfg2.if	2.9 KB	-rw-r--r--
bind.if	7.84 KB	-rw-r--r--
bitlbee.if	1.26 KB	-rw-r--r--
bluetooth.if	5.63 KB	-rw-r--r--
boinc.if	3.01 KB	-rw-r--r--
bugzilla.if	851 B	-rw-r--r--
cachefilesd.if	1.2 KB	-rw-r--r--
canna.if	1.35 KB	-rw-r--r--
ccs.if	1.45 KB	-rw-r--r--
certmaster.if	3.09 KB	-rw-r--r--
certmonger.if	5.09 KB	-rw-r--r--
cfengine.if	2.98 KB	-rw-r--r--
cgdcbxd.if	1.3 KB	-rw-r--r--
cgroup.if	3.14 KB	-rw-r--r--
chronyd.if	3.61 KB	-rw-r--r--
cinder.if	1.33 KB	-rw-r--r--
cipe.if	46 B	-rw-r--r--
clamav.if	4.23 KB	-rw-r--r--
clockspeed.if	952 B	-rw-r--r--
clogd.if	1.89 KB	-rw-r--r--
cloudform.if	809 B	-rw-r--r--
cmirrord.if	2.56 KB	-rw-r--r--
cobbler.if	4.83 KB	-rw-r--r--
collectd.if	3.03 KB	-rw-r--r--
comsat.if	45 B	-rw-r--r--
condor.if	6.91 KB	-rw-r--r--
conman.if	1.51 KB	-rw-r--r--
consolekit.if	2.63 KB	-rw-r--r--
corosync.if	3.87 KB	-rw-r--r--
courier.if	5.2 KB	-rw-r--r--
cpucontrol.if	382 B	-rw-r--r--
cron.if	15.03 KB	-rw-r--r--
ctdbd.if	5.61 KB	-rw-r--r--
cups.if	6.95 KB	-rw-r--r--
cvs.if	2 KB	-rw-r--r--
cyphesis.if	412 B	-rw-r--r--
cyrus.if	2.13 KB	-rw-r--r--
dante.if	62 B	-rw-r--r--
dbskk.if	82 B	-rw-r--r--
dbus.if	12.09 KB	-rw-r--r--
dcc.if	3.35 KB	-rw-r--r--
ddclient.if	2.03 KB	-rw-r--r--
denyhosts.if	1.93 KB	-rw-r--r--
devicekit.if	4.91 KB	-rw-r--r--
dhcp.if	1.99 KB	-rw-r--r--
dictd.if	1.24 KB	-rw-r--r--
dirsrv-admin.if	3.36 KB	-rw-r--r--
dirsrv.if	5.29 KB	-rw-r--r--
distcc.if	50 B	-rw-r--r--
djbdns.if	2.46 KB	-rw-r--r--
dkim.if	57 B	-rw-r--r--
dnsmasq.if	4.97 KB	-rw-r--r--
dovecot.if	4.32 KB	-rw-r--r--
drbd.if	2.24 KB	-rw-r--r--
dspam.if	5.09 KB	-rw-r--r--
exim.if	4.81 KB	-rw-r--r--
fail2ban.if	4.47 KB	-rw-r--r--
fcoemon.if	1.56 KB	-rw-r--r--
fetchmail.if	713 B	-rw-r--r--
finger.if	747 B	-rw-r--r--
fprintd.if	790 B	-rw-r--r--
freeipmi.if	1.77 KB	-rw-r--r--
ftp.if	4.4 KB	-rw-r--r--
gatekeeper.if	57 B	-rw-r--r--
git.if	1.67 KB	-rw-r--r--
glance.if	5.2 KB	-rw-r--r--
glusterd.if	4.29 KB	-rw-r--r--
gnomeclock.if	1.72 KB	-rw-r--r--
gpm.if	1.52 KB	-rw-r--r--
gpsd.if	1.28 KB	-rw-r--r--
hal.if	8.23 KB	-rw-r--r--
hddtemp.if	722 B	-rw-r--r--
howl.if	352 B	-rw-r--r--
hypervkvp.if	1.58 KB	-rw-r--r--
i18n_input.if	327 B	-rw-r--r--
icecast.if	3.59 KB	-rw-r--r--
ifplugd.if	2.66 KB	-rw-r--r--
imaze.if	40 B	-rw-r--r--
inetd.if	4.32 KB	-rw-r--r--
inn.if	4.33 KB	-rw-r--r--
ipmievd.if	1.81 KB	-rw-r--r--
ircd.if	33 B	-rw-r--r--
irqbalance.if	43 B	-rw-r--r--
isns.if	880 B	-rw-r--r--
jabber.if	3.21 KB	-rw-r--r--
keepalived.if	475 B	-rw-r--r--
kerberos.if	9.23 KB	-rw-r--r--
kerneloops.if	2.41 KB	-rw-r--r--
keystone.if	3.95 KB	-rw-r--r--
ksmtuned.if	1.57 KB	-rw-r--r--
ktalk.if	38 B	-rw-r--r--
l2tpd.if	3.37 KB	-rw-r--r--
ldap.if	3.97 KB	-rw-r--r--
likewise.if	2.44 KB	-rw-r--r--
linuxptp.if	2.72 KB	-rw-r--r--
lircd.if	1.93 KB	-rw-r--r--
lldpad.if	1.97 KB	-rw-r--r--
lpd.if	4 KB	-rw-r--r--
lsm.if	753 B	-rw-r--r--
mailman.if	8.55 KB	-rw-r--r--
matahari.if	5.21 KB	-rw-r--r--
memcached.if	2.4 KB	-rw-r--r--
milter.if	3.43 KB	-rw-r--r--
mip6d.if	432 B	-rw-r--r--
mirrormanager.if	5.17 KB	-rw-r--r--
modemmanager.if	905 B	-rw-r--r--
monop.if	38 B	-rw-r--r--
mpd.if	5.73 KB	-rw-r--r--
mta.if	22.27 KB	-rw-r--r--
munin.if	4.66 KB	-rw-r--r--
mysql.if	8.46 KB	-rw-r--r--
nagios.if	7.73 KB	-rw-r--r--
nessus.if	349 B	-rw-r--r--
networkmanager.if	5.4 KB	-rw-r--r--
nis.if	8.57 KB	-rw-r--r--
nova.if	1.17 KB	-rw-r--r--
nscd.if	6.18 KB	-rw-r--r--
nsd.if	634 B	-rw-r--r--
nslcd.if	2.31 KB	-rw-r--r--
ntop.if	2.98 KB	-rw-r--r--
ntp.if	3.56 KB	-rw-r--r--
numad.if	762 B	-rw-r--r--
nut.if	47 B	-rw-r--r--
nx.if	1.78 KB	-rw-r--r--
oav.if	973 B	-rw-r--r--
oddjob.if	3.88 KB	-rw-r--r--
oident.if	1.47 KB	-rw-r--r--
openca.if	1.37 KB	-rw-r--r--
openct.if	1.78 KB	-rw-r--r--
openhpid.if	2.94 KB	-rw-r--r--
openshift-origin.if	23 B	-rw-r--r--
openshift.if	13.75 KB	-rw-r--r--
openvpn.if	3.2 KB	-rw-r--r--
openvswitch.if	3.37 KB	-rw-r--r--
openwsman.if	428 B	-rw-r--r--
oracleasm.if	1.42 KB	-rw-r--r--
osad.if	3 KB	-rw-r--r--
pacemaker.if	3.41 KB	-rw-r--r--
pads.if	1.05 KB	-rw-r--r--
passenger.if	3.44 KB	-rw-r--r--
pcp.if	2.8 KB	-rw-r--r--
pcscd.if	1.8 KB	-rw-r--r--
pegasus.if	62 B	-rw-r--r--
perdition.if	378 B	-rw-r--r--
pingd.if	1.96 KB	-rw-r--r--
piranha.if	4.14 KB	-rw-r--r--
pkcsslotd.if	2.34 KB	-rw-r--r--
plymouthd.if	6.52 KB	-rw-r--r--
policykit.if	5.65 KB	-rw-r--r--
portmap.if	1.92 KB	-rw-r--r--
portreserve.if	2.7 KB	-rw-r--r--
portslave.if	419 B	-rw-r--r--
postfix.if	19.5 KB	-rw-r--r--
postfixpolicyd.if	1022 B	-rw-r--r--
postgresql.if	15.28 KB	-rw-r--r--
postgrey.if	1.8 KB	-rw-r--r--
ppp.if	7.1 KB	-rw-r--r--
prelude.if	3.23 KB	-rw-r--r--
privoxy.if	972 B	-rw-r--r--
procmail.if	1.84 KB	-rw-r--r--
psad.if	5.39 KB	-rw-r--r--
publicfile.if	83 B	-rw-r--r--
puppet.if	5.12 KB	-rw-r--r--
pxe.if	63 B	-rw-r--r--
pyicqt.if	66 B	-rw-r--r--
pyzor.if	2.71 KB	-rw-r--r--
qmail.if	4.16 KB	-rw-r--r--
qpidd.if	5.02 KB	-rw-r--r--
quantum.if	4.68 KB	-rw-r--r--
radius.if	1.37 KB	-rw-r--r--
radvd.if	1.18 KB	-rw-r--r--
razor.if	5.12 KB	-rw-r--r--
rdisc.if	373 B	-rw-r--r--
redis.if	4.83 KB	-rw-r--r--
remotelogin.if	779 B	-rw-r--r--
resmgr.if	465 B	-rw-r--r--
rgmanager.if	4.6 KB	-rw-r--r--
rhcs.if	16.67 KB	-rw-r--r--
rhev.if	2.04 KB	-rw-r--r--
rhgb.if	3.57 KB	-rw-r--r--
rhnsd.if	1.73 KB	-rw-r--r--
rhsmcertd.if	5.95 KB	-rw-r--r--
ricci.if	6.3 KB	-rw-r--r--
rlogin.if	925 B	-rw-r--r--
roundup.if	938 B	-rw-r--r--
rpc.if	9.53 KB	-rw-r--r--
rpcbind.if	3.1 KB	-rw-r--r--
rshd.if	428 B	-rw-r--r--
rsync.if	3.62 KB	-rw-r--r--
rtas.if	2.54 KB	-rw-r--r--
rtkit.if	1.67 KB	-rw-r--r--
rwho.if	2.89 KB	-rw-r--r--
samba.if	19.02 KB	-rw-r--r--
sanlock.if	2.23 KB	-rw-r--r--
sasl.if	1.17 KB	-rw-r--r--
sblim.if	3.54 KB	-rw-r--r--
sendmail.if	7 KB	-rw-r--r--
sensord.if	817 B	-rw-r--r--
setroubleshoot.if	3.49 KB	-rw-r--r--
sge.if	54 B	-rw-r--r--
slpd.if	1.36 KB	-rw-r--r--
slrnpull.if	978 B	-rw-r--r--
smartmon.if	1.26 KB	-rw-r--r--
smokeping.if	3.32 KB	-rw-r--r--
smstools.if	2.57 KB	-rw-r--r--
snmp.if	4.93 KB	-rw-r--r--
snort.if	1.29 KB	-rw-r--r--
soundserver.if	1.3 KB	-rw-r--r--
spamassassin.if	7.62 KB	-rw-r--r--
speedtouch.if	56 B	-rw-r--r--
squid.if	4.32 KB	-rw-r--r--
ssh.if	23.08 KB	-rw-r--r--
sssd.if	5.23 KB	-rw-r--r--
stapserver.if	3.04 KB	-rw-r--r--
stunnel.if	577 B	-rw-r--r--
svnserve.if	1.57 KB	-rw-r--r--
swift.if	1.82 KB	-rw-r--r--
sysstat.if	433 B	-rw-r--r--
tcpd.if	903 B	-rw-r--r--
telnet.if	36 B	-rw-r--r--
tftp.if	3.12 KB	-rw-r--r--
tgtd.if	1.46 KB	-rw-r--r--
timidity.if	79 B	-rw-r--r--
tomcat.if	7.27 KB	-rw-r--r--
tor.if	1.31 KB	-rw-r--r--
transproxy.if	45 B	-rw-r--r--
tuned.if	2.45 KB	-rw-r--r--
ucspitcp.if	642 B	-rw-r--r--
ulogd.if	2.91 KB	-rw-r--r--
uptime.if	36 B	-rw-r--r--
usbmuxd.if	863 B	-rw-r--r--
uucp.if	2.35 KB	-rw-r--r--
uuidd.if	3.61 KB	-rw-r--r--
uwimap.if	461 B	-rw-r--r--
varnishd.if	4.42 KB	-rw-r--r--
vdagent.if	2.36 KB	-rw-r--r--
vhostmd.if	4.43 KB	-rw-r--r--
virt.if	19.61 KB	-rw-r--r--
w3c.if	43 B	-rw-r--r--
watchdog.if	895 B	-rw-r--r--
wdmd.if	2.49 KB	-rw-r--r--
xfs.if	1.07 KB	-rw-r--r--
xprint.if	37 B	-rw-r--r--
xserver.if	37.77 KB	-rw-r--r--
zabbix.if	3.97 KB	-rw-r--r--
zarafa.if	4.04 KB	-rw-r--r--
zebra.if	1.88 KB	-rw-r--r--
zosremote.if	991 B	-rw-r--r--

Code Editor : postgresql.if

## <summary>PostgreSQL relational database</summary>

#######################################
## <summary>
##	Role access for SE-PostgreSQL.
## </summary>
## <param name="user_role">
##	<summary>
##	The role associated with the user domain.
##	</summary>
## </param>
## <param name="user_domain">
##	<summary>
##	The type of the user domain.
##	</summary>
## </param>
#
interface(`postgresql_role',`
	gen_require(`
		class db_database all_db_database_perms;
		class db_schema all_db_schema_perms;
		class db_table all_db_table_perms;
		class db_sequence all_db_sequence_perms;
		class db_view all_db_view_perms;
		class db_procedure all_db_procedure_perms;
		class db_language all_db_language_perms;
		class db_column all_db_column_perms;
		class db_tuple all_db_tuple_perms;
		class db_blob all_db_blob_perms;

attribute sepgsql_client_type, sepgsql_database_type;
		attribute sepgsql_schema_type, sepgsql_sysobj_table_type;

type sepgsql_trusted_proc_exec_t, sepgsql_trusted_proc_t;
		type user_sepgsql_blob_t, user_sepgsql_proc_exec_t;
		type user_sepgsql_schema_t, user_sepgsql_seq_t;
		type user_sepgsql_sysobj_t, user_sepgsql_table_t;
		type user_sepgsql_view_t;
	')

########################################
	#
	# Declarations
	#

typeattribute $2 sepgsql_client_type;
	role $1 types sepgsql_trusted_proc_t;

##############################
	#
	# Client local policy
	#

allow $2 user_sepgsql_schema_t:db_schema { getattr search add_name remove_name };
	type_transition $2 sepgsql_database_type:db_schema user_sepgsql_schema_t;

allow $2 user_sepgsql_table_t:db_table	{ getattr use select update insert delete lock };
	allow $2 user_sepgsql_table_t:db_column { getattr use select update insert };
	allow $2 user_sepgsql_table_t:db_tuple	{ use select update insert delete };
	type_transition $2 sepgsql_database_type:db_table user_sepgsql_table_t;		# deprecated
	type_transition $2 sepgsql_schema_type:db_table user_sepgsql_table_t;

allow $2 user_sepgsql_sysobj_t:db_tuple	{ use select };
	type_transition $2 sepgsql_sysobj_table_type:db_tuple user_sepgsql_sysobj_t;

allow $2 user_sepgsql_seq_t:db_sequence { getattr get_value next_value };
	type_transition $2 sepgsql_schema_type:db_sequence user_sepgsql_seq_t;

allow $2 user_sepgsql_view_t:db_view { getattr expand };
	type_transition $2 sepgsql_schema_type:db_view user_sepgsql_view_t;

allow $2 user_sepgsql_proc_exec_t:db_procedure { getattr execute };
	type_transition $2 sepgsql_database_type:db_procedure user_sepgsql_proc_exec_t;	# deprecated
	type_transition $2 sepgsql_schema_type:db_procedure user_sepgsql_proc_exec_t;

allow $2 user_sepgsql_blob_t:db_blob { create drop getattr setattr read write import export };
	type_transition $2 sepgsql_database_type:db_blob user_sepgsql_blob_t;

allow $2 sepgsql_trusted_proc_t:process transition;
	type_transition $2 sepgsql_trusted_proc_exec_t:process sepgsql_trusted_proc_t;

tunable_policy(`sepgsql_enable_users_ddl',`
		allow $2 user_sepgsql_schema_t:db_schema { create drop setattr };
		allow $2 user_sepgsql_table_t:db_table { create drop setattr };
		allow $2 user_sepgsql_table_t:db_column { create drop setattr };
		allow $2 user_sepgsql_sysobj_t:db_tuple { update insert delete };
		allow $2 user_sepgsql_seq_t:db_sequence { create drop setattr set_value };
		allow $2 user_sepgsql_view_t:db_view { create drop setattr };
		allow $2 user_sepgsql_proc_exec_t:db_procedure { create drop setattr };
	')
')

########################################
## <summary>
##	Marks as a SE-PostgreSQL loadable shared library module
## </summary>
## <param name="type">
##	<summary>
##	Type marked as a database object type.
##	</summary>
## </param>
#
interface(`postgresql_loadable_module',`
	gen_require(`
		attribute sepgsql_module_type;
	')

typeattribute $1 sepgsql_module_type;
')

########################################
## <summary>
##	Marks as a SE-PostgreSQL database object type
## </summary>
## <param name="type">
##	<summary>
##	Type marked as a database object type.
##	</summary>
## </param>
#
interface(`postgresql_database_object',`
	gen_require(`
		attribute sepgsql_database_type;
	')

typeattribute $1 sepgsql_database_type;
')

########################################
## <summary>
##	Marks as a SE-PostgreSQL schema object type
## </summary>
## <param name="type">
##	<summary>
##	Type marked as a schema object type.
##	</summary>
## </param>
#
interface(`postgresql_schema_object',`
	gen_require(`
		attribute sepgsql_schema_type;
	')

typeattribute $1 sepgsql_schema_type;
')

########################################
## <summary>
##	Marks as a SE-PostgreSQL table/column/tuple object type
## </summary>
## <param name="type">
##	<summary>
##	Type marked as a table/column/tuple object type.
##	</summary>
## </param>
#
interface(`postgresql_table_object',`
	gen_require(`
		attribute sepgsql_table_type;
	')

typeattribute $1 sepgsql_table_type;
')

########################################
## <summary>
##	Marks as a SE-PostgreSQL system table/column/tuple object type
## </summary>
## <param name="type">
##	<summary>
##	Type marked as a table/column/tuple object type.
##	</summary>
## </param>
#
interface(`postgresql_system_table_object',`
	gen_require(`
		attribute sepgsql_table_type, sepgsql_sysobj_table_type;
	')

typeattribute $1 sepgsql_table_type;
	typeattribute $1 sepgsql_sysobj_table_type;
')

########################################
## <summary>
##	Marks as a SE-PostgreSQL sequence type
## </summary>
## <param name="type">
##	<summary>
##	Type marked as a sequence type.
##	</summary>
## </param>
#
interface(`postgresql_sequence_object',`
	gen_require(`
		attribute sepgsql_sequence_type;
	')

typeattribute $1 sepgsql_sequence_type;
')

########################################
## <summary>
##	Marks as a SE-PostgreSQL view object type
## </summary>
## <param name="type">
##	<summary>
##	Type marked as a view object type.
##	</summary>
## </param>
#
interface(`postgresql_view_object',`
	gen_require(`
		attribute sepgsql_view_type;
	')

typeattribute $1 sepgsql_view_type;
')

########################################
## <summary>
##	Marks as a SE-PostgreSQL procedure object type
## </summary>
## <param name="type">
##	<summary>
##	Type marked as a database object type.
##	</summary>
## </param>
#
interface(`postgresql_procedure_object',`
	gen_require(`
		attribute sepgsql_procedure_type;
	')

typeattribute $1 sepgsql_procedure_type;
')

########################################
## <summary>
##	Marks as a SE-PostgreSQL procedural language object type
## </summary>
## <param name="type">
##	<summary>
##	Type marked as a procedural language object type.
##	</summary>
## </param>
#
interface(`postgresql_language_object',`
	gen_require(`
		attribute sepgsql_language_type;
	')

typeattribute $1 sepgsql_language_type;
')

########################################
## <summary>
##	Marks as a SE-PostgreSQL binary large object type
## </summary>
## <param name="type">
##	<summary>
##	Type marked as a database binary large object type.
##	</summary>
## </param>
#
interface(`postgresql_blob_object',`
	gen_require(`
		attribute sepgsql_blob_type;
	')

typeattribute $1 sepgsql_blob_type;
')

########################################
## <summary>
##	Allow the specified domain to search postgresql's database directory.
## </summary>
## <param name="domain">
##	<summary>
##	Domain allowed access.
##	</summary>
## </param>
#
interface(`postgresql_search_db',`
	gen_require(`
		type postgresql_db_t;
	')

allow $1 postgresql_db_t:dir search_dir_perms;
')

########################################
## <summary>
##	Allow the specified domain to manage postgresql's database.
## </summary>
## <param name="domain">
##	<summary>
##	Domain allowed access.
##	</summary>
## </param>
#
interface(`postgresql_manage_db',`
	gen_require(`
		type postgresql_db_t;
	')

allow $1 postgresql_db_t:dir rw_dir_perms;
	allow $1 postgresql_db_t:file rw_file_perms;
	allow $1 postgresql_db_t:lnk_file read_lnk_file_perms;
')

########################################
## <summary>
##	Execute postgresql in the postgresql domain.
## </summary>
## <param name="domain">
##	<summary>
##	Domain allowed to transition.
##	</summary>
## </param>
#
interface(`postgresql_domtrans',`
	gen_require(`
		type postgresql_t, postgresql_exec_t;
	')

domtrans_pattern($1, postgresql_exec_t, postgresql_t)
')

######################################
## <summary>
##     Execute Postgresql in the caller domain.
## </summary>
## <param name="domain">
##     <summary>
##     Domain allowed access.
##     </summary>
## </param>
#
interface(`postgresql_exec',`
       gen_require(`
               type  postgresql_exec_t;
       ')

can_exec($1, postgresql_exec_t)
')

######################################
## <summary>
##	Allow domain to signal postgresql
## </summary>
## <param name="domain">
##	<summary>
##	Domain allowed access.
##	</summary>
## </param>
#
interface(`postgresql_signal',`
	gen_require(`
		type postgresql_t;
	')
	allow $1 postgresql_t:process signal;
')

########################################
## <summary>
##	Allow the specified domain to read postgresql's etc.
## </summary>
## <param name="domain">
##	<summary>
##	Domain allowed access.
##	</summary>
## </param>
## <rolecap/>
#
interface(`postgresql_read_config',`
	gen_require(`
		type postgresql_etc_t;
	')

files_search_etc($1)
	allow $1 postgresql_etc_t:dir list_dir_perms;
	allow $1 postgresql_etc_t:file read_file_perms;
	allow $1 postgresql_etc_t:lnk_file read_lnk_file_perms;
')

########################################
## <summary>
##	Allow the specified domain to connect to postgresql with a tcp socket.
## </summary>
## <param name="domain">
##	<summary>
##	Domain allowed access.
##	</summary>
## </param>
#
interface(`postgresql_tcp_connect',`
	gen_require(`
		type postgresql_t;
	')

corenet_tcp_recvfrom_labeled($1, postgresql_t)
	corenet_tcp_sendrecv_postgresql_port($1)
	corenet_tcp_connect_postgresql_port($1)
	corenet_sendrecv_postgresql_client_packets($1)
')

########################################
## <summary>
##	Allow the specified domain to connect to postgresql with a unix socket.
## </summary>
## <param name="domain">
##	<summary>
##	Domain allowed access.
##	</summary>
## </param>
#
interface(`postgresql_stream_connect',`
	gen_require(`
		type postgresql_t, postgresql_var_run_t, postgresql_tmp_t;
	')

files_search_pids($1)
	files_search_tmp($1)
	stream_connect_pattern($1, { postgresql_var_run_t postgresql_tmp_t }, { postgresql_var_run_t postgresql_tmp_t }, postgresql_t)
')

########################################
## <summary>
##	Allow the specified domain unprivileged accesses to unifined database objects
##	managed by SE-PostgreSQL,
## </summary>
## <param name="domain">
##	<summary>
##	Domain allowed access.
##	</summary>
## </param>
#
interface(`postgresql_unpriv_client',`
	gen_require(`
		class db_database all_db_database_perms;
		class db_schema all_db_schema_perms;
		class db_table all_db_table_perms;
		class db_sequence all_db_sequence_perms;
		class db_view all_db_view_perms;
		class db_procedure all_db_procedure_perms;
		class db_language all_db_language_perms;
		class db_column all_db_column_perms;
		class db_tuple all_db_tuple_perms;
		class db_blob all_db_blob_perms;

attribute sepgsql_client_type;
		attribute sepgsql_database_type, sepgsql_schema_type;
		attribute sepgsql_sysobj_table_type;

type sepgsql_trusted_proc_t, sepgsql_trusted_proc_exec_t;
		type unpriv_sepgsql_blob_t, unpriv_sepgsql_proc_exec_t;
		type unpriv_sepgsql_schema_t, unpriv_sepgsql_seq_t;
		type unpriv_sepgsql_sysobj_t, unpriv_sepgsql_table_t;
		type unpriv_sepgsql_view_t;
	')

########################################
	#
	# Declarations
	#

typeattribute $1 sepgsql_client_type;

########################################
	#
	# Client local policy
	#

type_transition $1 sepgsql_trusted_proc_exec_t:process sepgsql_trusted_proc_t;
	allow $1 sepgsql_trusted_proc_t:process transition;

tunable_policy(`sepgsql_enable_users_ddl',`
		allow $1 unpriv_sepgsql_schema_t:db_schema { create drop setattr };
		allow $1 unpriv_sepgsql_table_t:db_table { create drop setattr };
		allow $1 unpriv_sepgsql_table_t:db_column { create drop setattr };
		allow $1 unpriv_sepgsql_sysobj_t:db_tuple { update insert delete };
		allow $1 unpriv_sepgsql_seq_t:db_sequence { create drop setattr };
		allow $1 unpriv_sepgsql_view_t:db_view { create drop setattr };
		allow $1 unpriv_sepgsql_proc_exec_t:db_procedure { create drop setattr };
	')

allow $1 unpriv_sepgsql_schema_t:db_schema { getattr add_name remove_name };
	type_transition $1 sepgsql_database_type:db_schema unpriv_sepgsql_schema_t;

allow $1 unpriv_sepgsql_table_t:db_table { getattr use select update insert delete lock };
	allow $1 unpriv_sepgsql_table_t:db_column { getattr use select update insert };
	allow $1 unpriv_sepgsql_table_t:db_tuple { use select update insert delete };
	type_transition $1 sepgsql_database_type:db_table unpriv_sepgsql_table_t;	# deprecated
	type_transition $1 sepgsql_schema_type:db_table unpriv_sepgsql_table_t;

allow $1 unpriv_sepgsql_seq_t:db_sequence { getattr get_value next_value set_value };
	type_transition $1 sepgsql_schema_type:db_sequence unpriv_sepgsql_seq_t;

allow $1 unpriv_sepgsql_view_t:db_view { getattr expand };
	type_transition $1 sepgsql_schema_type:db_view unpriv_sepgsql_view_t;

allow $1 unpriv_sepgsql_sysobj_t:db_tuple { use select };
	type_transition $1 sepgsql_sysobj_table_type:db_tuple unpriv_sepgsql_sysobj_t;

allow $1 unpriv_sepgsql_proc_exec_t:db_procedure { getattr execute };
	type_transition $1 sepgsql_database_type:db_procedure unpriv_sepgsql_proc_exec_t; # deprecated
	type_transition $1 sepgsql_schema_type:db_procedure unpriv_sepgsql_proc_exec_t;

allow $1 unpriv_sepgsql_blob_t:db_blob { create drop getattr setattr read write import export };
	type_transition $1 sepgsql_database_type:db_blob unpriv_sepgsql_blob_t;

########################################
## <summary>
##	Allow the specified domain unconfined accesses to any database objects
##	managed by SE-PostgreSQL,
## </summary>
## <param name="domain">
##	<summary>
##	Domain allowed access.
##	</summary>
## </param>
#
interface(`postgresql_unconfined',`
	gen_require(`
		attribute sepgsql_unconfined_type;
	')

typeattribute $1 sepgsql_unconfined_type;
')

########################################
## <summary>
##	All of the rules required to administrate an postgresql environment
## </summary>
## <param name="domain">
##	<summary>
##	Domain allowed access.
##	</summary>
## </param>
## <param name="role">
##	<summary>
##	The role to be allowed to manage the postgresql domain.
##	</summary>
## </param>
## <rolecap/>
#
interface(`postgresql_admin',`
	gen_require(`
		attribute sepgsql_admin_type, sepgsql_client_type;
		type postgresql_t, postgresql_var_run_t, postgresql_initrc_exec_t;
		type postgresql_tmp_t, postgresql_db_t, postgresql_log_t;
		type postgresql_etc_t;
	')

typeattribute $1 sepgsql_admin_type;

allow $1 postgresql_t:process { ptrace signal_perms };
	ps_process_pattern($1, postgresql_t)

init_labeled_script_domtrans($1, postgresql_initrc_exec_t)
	domain_system_change_exemption($1)
	role_transition $2 postgresql_initrc_exec_t system_r;
	allow $2 system_r;

files_list_pids($1)
	admin_pattern($1, postgresql_var_run_t)

files_list_var_lib($1)
	admin_pattern($1, postgresql_db_t)

files_list_etc($1)
	admin_pattern($1, postgresql_etc_t)

logging_list_logs($1)
	admin_pattern($1, postgresql_log_t)

files_list_tmp($1)
	admin_pattern($1, postgresql_tmp_t)

postgresql_tcp_connect($1)
	postgresql_stream_connect($1)
')

${this.title}

Code Editor : postgresql.if