|
Chris PeBenito |
17de1b7 |
## <summary>PostgreSQL relational database</summary>
|
|
Chris PeBenito |
17de1b7 |
|
|
Chris PeBenito |
e8cb08a |
#######################################
|
|
Chris PeBenito |
e8cb08a |
## <summary>
|
|
Chris PeBenito |
ff8f0a6 |
## Role access for SE-PostgreSQL.
|
|
Chris PeBenito |
e8cb08a |
## </summary>
|
|
Chris PeBenito |
296273a |
## <param name="user_role">
|
|
Chris PeBenito |
ff8f0a6 |
## <summary>
|
|
Chris PeBenito |
ff8f0a6 |
## The role associated with the user domain.
|
|
Chris PeBenito |
ff8f0a6 |
## </summary>
|
|
Chris PeBenito |
e8cb08a |
## </param>
|
|
Chris PeBenito |
e8cb08a |
## <param name="user_domain">
|
|
Dominick Grift |
2a72457 |
## <summary>
|
|
Chris PeBenito |
ff8f0a6 |
## The type of the user domain.
|
|
Chris PeBenito |
ff8f0a6 |
## </summary>
|
|
Chris PeBenito |
e8cb08a |
## </param>
|
|
Chris PeBenito |
e8cb08a |
#
|
|
Chris PeBenito |
296273a |
interface(`postgresql_role',`
|
|
Chris PeBenito |
e8cb08a |
gen_require(`
|
|
Chris PeBenito |
e8cb08a |
class db_database all_db_database_perms;
|
|
Chris PeBenito |
e8cb08a |
class db_table all_db_table_perms;
|
|
Chris PeBenito |
e8cb08a |
class db_procedure all_db_procedure_perms;
|
|
Chris PeBenito |
e8cb08a |
class db_column all_db_column_perms;
|
|
Chris PeBenito |
e8cb08a |
class db_tuple all_db_tuple_perms;
|
|
Chris PeBenito |
e8cb08a |
class db_blob all_db_blob_perms;
|
|
Chris PeBenito |
e8cb08a |
|
|
Chris PeBenito |
e8cb08a |
attribute sepgsql_client_type, sepgsql_database_type;
|
|
Chris PeBenito |
e8cb08a |
attribute sepgsql_sysobj_table_type;
|
|
Chris PeBenito |
e8cb08a |
|
|
Chris PeBenito |
7f4005e |
type sepgsql_trusted_proc_exec_t, sepgsql_trusted_proc_t;
|
|
Chris PeBenito |
296273a |
type user_sepgsql_blob_t, user_sepgsql_proc_exec_t;
|
|
Chris PeBenito |
296273a |
type user_sepgsql_sysobj_t, user_sepgsql_table_t;
|
|
Chris PeBenito |
e8cb08a |
')
|
|
Chris PeBenito |
e8cb08a |
|
|
Chris PeBenito |
e8cb08a |
########################################
|
|
Chris PeBenito |
e8cb08a |
#
|
|
Chris PeBenito |
e8cb08a |
# Declarations
|
|
Chris PeBenito |
e8cb08a |
#
|
|
Chris PeBenito |
e8cb08a |
|
|
Chris PeBenito |
e8cb08a |
typeattribute $2 sepgsql_client_type;
|
|
Chris PeBenito |
296273a |
role $1 types sepgsql_trusted_proc_t;
|
|
Chris PeBenito |
e8cb08a |
|
|
Chris PeBenito |
e8cb08a |
##############################
|
|
Chris PeBenito |
e8cb08a |
#
|
|
Chris PeBenito |
e8cb08a |
# Client local policy
|
|
Chris PeBenito |
e8cb08a |
#
|
|
Chris PeBenito |
e8cb08a |
|
|
Chris PeBenito |
3f67f72 |
allow $2 user_sepgsql_table_t:db_table { getattr use select update insert delete lock };
|
|
Chris PeBenito |
e0ea7b1 |
allow $2 user_sepgsql_table_t:db_column { getattr use select update insert };
|
|
Chris PeBenito |
6073ea1 |
allow $2 user_sepgsql_table_t:db_tuple { use select update insert delete };
|
|
Chris PeBenito |
a01a4a7 |
type_transition $2 sepgsql_database_type:db_table user_sepgsql_table_t;
|
|
Chris PeBenito |
a01a4a7 |
|
|
Chris PeBenito |
6073ea1 |
allow $2 user_sepgsql_sysobj_t:db_tuple { use select };
|
|
Chris PeBenito |
a01a4a7 |
type_transition $2 sepgsql_sysobj_table_type:db_tuple user_sepgsql_sysobj_t;
|
|
Chris PeBenito |
e8cb08a |
|
|
Chris PeBenito |
e0ea7b1 |
allow $2 user_sepgsql_proc_exec_t:db_procedure { getattr execute };
|
|
Chris PeBenito |
296273a |
type_transition $2 sepgsql_database_type:db_procedure user_sepgsql_proc_exec_t;
|
|
Chris PeBenito |
e8cb08a |
|
|
Chris PeBenito |
996779d |
allow $2 user_sepgsql_blob_t:db_blob { create drop getattr setattr read write import export };
|
|
Chris PeBenito |
296273a |
type_transition $2 sepgsql_database_type:db_blob user_sepgsql_blob_t;
|
|
Chris PeBenito |
e8cb08a |
|
|
Chris PeBenito |
7f4005e |
allow $2 sepgsql_trusted_proc_t:process transition;
|
|
Chris PeBenito |
7f4005e |
type_transition $2 sepgsql_trusted_proc_exec_t:process sepgsql_trusted_proc_t;
|
|
Dominick Grift |
b46b3ad |
|
|
Dominick Grift |
b46b3ad |
tunable_policy(`sepgsql_enable_users_ddl',`
|
|
Dominick Grift |
b46b3ad |
allow $2 user_sepgsql_table_t:db_table { create drop setattr };
|
|
Dominick Grift |
b46b3ad |
allow $2 user_sepgsql_table_t:db_column { create drop setattr };
|
|
Dominick Grift |
b46b3ad |
|
|
Dominick Grift |
b46b3ad |
allow $2 user_sepgsql_sysobj_t:db_tuple { update insert delete };
|
|
Dominick Grift |
b46b3ad |
allow $2 user_sepgsql_proc_exec_t:db_procedure { create drop setattr };
|
|
Dominick Grift |
b46b3ad |
')
|
|
Chris PeBenito |
e8cb08a |
')
|
|
Chris PeBenito |
e8cb08a |
|
|
Chris PeBenito |
e8cb08a |
########################################
|
|
Chris PeBenito |
e8cb08a |
## <summary>
|
|
Chris PeBenito |
ff8f0a6 |
## Marks as a SE-PostgreSQL loadable shared library module
|
|
Chris PeBenito |
e8cb08a |
## </summary>
|
|
Chris PeBenito |
e8cb08a |
## <param name="type">
|
|
Chris PeBenito |
ff8f0a6 |
## <summary>
|
|
Chris PeBenito |
ff8f0a6 |
## Type marked as a database object type.
|
|
Chris PeBenito |
ff8f0a6 |
## </summary>
|
|
Chris PeBenito |
e8cb08a |
## </param>
|
|
Chris PeBenito |
e8cb08a |
#
|
|
Chris PeBenito |
e8cb08a |
interface(`postgresql_loadable_module',`
|
|
Chris PeBenito |
e8cb08a |
gen_require(`
|
|
Chris PeBenito |
e8cb08a |
attribute sepgsql_module_type;
|
|
Chris PeBenito |
e8cb08a |
')
|
|
Chris PeBenito |
e8cb08a |
|
|
Chris PeBenito |
e8cb08a |
typeattribute $1 sepgsql_module_type;
|
|
Chris PeBenito |
e8cb08a |
')
|
|
Chris PeBenito |
e8cb08a |
|
|
Chris PeBenito |
e8cb08a |
########################################
|
|
Chris PeBenito |
e8cb08a |
## <summary>
|
|
Chris PeBenito |
ff8f0a6 |
## Marks as a SE-PostgreSQL database object type
|
|
Chris PeBenito |
e8cb08a |
## </summary>
|
|
Chris PeBenito |
e8cb08a |
## <param name="type">
|
|
Chris PeBenito |
ff8f0a6 |
## <summary>
|
|
Chris PeBenito |
ff8f0a6 |
## Type marked as a database object type.
|
|
Chris PeBenito |
ff8f0a6 |
## </summary>
|
|
Chris PeBenito |
e8cb08a |
## </param>
|
|
Chris PeBenito |
e8cb08a |
#
|
|
Chris PeBenito |
e8cb08a |
interface(`postgresql_database_object',`
|
|
Chris PeBenito |
e8cb08a |
gen_require(`
|
|
Chris PeBenito |
e8cb08a |
attribute sepgsql_database_type;
|
|
Chris PeBenito |
e8cb08a |
')
|
|
Chris PeBenito |
e8cb08a |
|
|
Chris PeBenito |
e8cb08a |
typeattribute $1 sepgsql_database_type;
|
|
Chris PeBenito |
e8cb08a |
')
|
|
Chris PeBenito |
e8cb08a |
|
|
Chris PeBenito |
e8cb08a |
########################################
|
|
Chris PeBenito |
e8cb08a |
## <summary>
|
|
Chris PeBenito |
ff8f0a6 |
## Marks as a SE-PostgreSQL table/column/tuple object type
|
|
Chris PeBenito |
e8cb08a |
## </summary>
|
|
Chris PeBenito |
e8cb08a |
## <param name="type">
|
|
Chris PeBenito |
ff8f0a6 |
## <summary>
|
|
Chris PeBenito |
ff8f0a6 |
## Type marked as a table/column/tuple object type.
|
|
Chris PeBenito |
ff8f0a6 |
## </summary>
|
|
Chris PeBenito |
e8cb08a |
## </param>
|
|
Chris PeBenito |
e8cb08a |
#
|
|
Chris PeBenito |
e8cb08a |
interface(`postgresql_table_object',`
|
|
Chris PeBenito |
e8cb08a |
gen_require(`
|
|
Chris PeBenito |
e8cb08a |
attribute sepgsql_table_type;
|
|
Chris PeBenito |
e8cb08a |
')
|
|
Chris PeBenito |
e8cb08a |
|
|
Chris PeBenito |
e8cb08a |
typeattribute $1 sepgsql_table_type;
|
|
Chris PeBenito |
e8cb08a |
')
|
|
Chris PeBenito |
e8cb08a |
|
|
Chris PeBenito |
e8cb08a |
########################################
|
|
Chris PeBenito |
e8cb08a |
## <summary>
|
|
Chris PeBenito |
ff8f0a6 |
## Marks as a SE-PostgreSQL system table/column/tuple object type
|
|
Chris PeBenito |
e8cb08a |
## </summary>
|
|
Chris PeBenito |
e8cb08a |
## <param name="type">
|
|
Chris PeBenito |
ff8f0a6 |
## <summary>
|
|
Chris PeBenito |
ff8f0a6 |
## Type marked as a table/column/tuple object type.
|
|
Chris PeBenito |
ff8f0a6 |
## </summary>
|
|
Chris PeBenito |
e8cb08a |
## </param>
|
|
Chris PeBenito |
e8cb08a |
#
|
|
Chris PeBenito |
e8cb08a |
interface(`postgresql_system_table_object',`
|
|
Chris PeBenito |
e8cb08a |
gen_require(`
|
|
Chris PeBenito |
0bfccda |
attribute sepgsql_table_type, sepgsql_sysobj_table_type;
|
|
Chris PeBenito |
e8cb08a |
')
|
|
Chris PeBenito |
e8cb08a |
|
|
Chris PeBenito |
e8cb08a |
typeattribute $1 sepgsql_table_type;
|
|
Chris PeBenito |
e8cb08a |
typeattribute $1 sepgsql_sysobj_table_type;
|
|
Chris PeBenito |
e8cb08a |
')
|
|
Chris PeBenito |
e8cb08a |
|
|
Chris PeBenito |
e8cb08a |
########################################
|
|
Chris PeBenito |
e8cb08a |
## <summary>
|
|
Chris PeBenito |
ff8f0a6 |
## Marks as a SE-PostgreSQL procedure object type
|
|
Chris PeBenito |
e8cb08a |
## </summary>
|
|
Chris PeBenito |
e8cb08a |
## <param name="type">
|
|
Chris PeBenito |
ff8f0a6 |
## <summary>
|
|
Chris PeBenito |
ff8f0a6 |
## Type marked as a database object type.
|
|
Chris PeBenito |
ff8f0a6 |
## </summary>
|
|
Chris PeBenito |
e8cb08a |
## </param>
|
|
Chris PeBenito |
e8cb08a |
#
|
|
Chris PeBenito |
e8cb08a |
interface(`postgresql_procedure_object',`
|
|
Chris PeBenito |
e8cb08a |
gen_require(`
|
|
Chris PeBenito |
e8cb08a |
attribute sepgsql_procedure_type;
|
|
Chris PeBenito |
e8cb08a |
')
|
|
Chris PeBenito |
e8cb08a |
|
|
Chris PeBenito |
e8cb08a |
typeattribute $1 sepgsql_procedure_type;
|
|
Chris PeBenito |
e8cb08a |
')
|
|
Chris PeBenito |
e8cb08a |
|
|
Chris PeBenito |
e8cb08a |
########################################
|
|
Chris PeBenito |
e8cb08a |
## <summary>
|
|
Chris PeBenito |
ff8f0a6 |
## Marks as a SE-PostgreSQL binary large object type
|
|
Chris PeBenito |
e8cb08a |
## </summary>
|
|
Chris PeBenito |
e8cb08a |
## <param name="type">
|
|
Chris PeBenito |
ff8f0a6 |
## <summary>
|
|
Chris PeBenito |
ff8f0a6 |
## Type marked as a database binary large object type.
|
|
Chris PeBenito |
ff8f0a6 |
## </summary>
|
|
Chris PeBenito |
e8cb08a |
## </param>
|
|
Chris PeBenito |
e8cb08a |
#
|
|
Chris PeBenito |
e8cb08a |
interface(`postgresql_blob_object',`
|
|
Chris PeBenito |
e8cb08a |
gen_require(`
|
|
Chris PeBenito |
e8cb08a |
attribute sepgsql_blob_type;
|
|
Chris PeBenito |
e8cb08a |
')
|
|
Chris PeBenito |
e8cb08a |
|
|
Chris PeBenito |
e8cb08a |
typeattribute $1 sepgsql_blob_type;
|
|
Chris PeBenito |
e8cb08a |
')
|
|
Chris PeBenito |
e8cb08a |
|
|
Chris PeBenito |
17de1b7 |
########################################
|
|
Chris PeBenito |
17de1b7 |
## <summary>
|
|
Chris PeBenito |
17de1b7 |
## Allow the specified domain to search postgresql's database directory.
|
|
Chris PeBenito |
17de1b7 |
## </summary>
|
|
Chris PeBenito |
17de1b7 |
## <param name="domain">
|
|
Chris PeBenito |
17de1b7 |
## <summary>
|
|
Chris PeBenito |
17de1b7 |
## Domain allowed access.
|
|
Chris PeBenito |
17de1b7 |
## </summary>
|
|
Chris PeBenito |
17de1b7 |
## </param>
|
|
Chris PeBenito |
17de1b7 |
#
|
|
Chris PeBenito |
17de1b7 |
interface(`postgresql_search_db',`
|
|
Chris PeBenito |
17de1b7 |
gen_require(`
|
|
Chris PeBenito |
17de1b7 |
type postgresql_db_t;
|
|
Chris PeBenito |
17de1b7 |
')
|
|
Chris PeBenito |
17de1b7 |
|
|
Dominick Grift |
69d1431 |
allow $1 postgresql_db_t:dir search_dir_perms;
|
|
Chris PeBenito |
17de1b7 |
')
|
|
Chris PeBenito |
17de1b7 |
|
|
Chris PeBenito |
17de1b7 |
########################################
|
|
Chris PeBenito |
17de1b7 |
## <summary>
|
|
Chris PeBenito |
17de1b7 |
## Allow the specified domain to manage postgresql's database.
|
|
Chris PeBenito |
17de1b7 |
## </summary>
|
|
Chris PeBenito |
17de1b7 |
## <param name="domain">
|
|
Chris PeBenito |
17de1b7 |
## <summary>
|
|
Chris PeBenito |
17de1b7 |
## Domain allowed access.
|
|
Chris PeBenito |
17de1b7 |
## </summary>
|
|
Chris PeBenito |
17de1b7 |
## </param>
|
|
Dominick Grift |
6123464 |
#
|
|
Chris PeBenito |
17de1b7 |
interface(`postgresql_manage_db',`
|
|
Chris PeBenito |
17de1b7 |
gen_require(`
|
|
Chris PeBenito |
17de1b7 |
type postgresql_db_t;
|
|
Chris PeBenito |
17de1b7 |
')
|
|
Chris PeBenito |
17de1b7 |
|
|
Chris PeBenito |
17de1b7 |
allow $1 postgresql_db_t:dir rw_dir_perms;
|
|
Chris PeBenito |
17de1b7 |
allow $1 postgresql_db_t:file rw_file_perms;
|
|
Dominick Grift |
69d1431 |
allow $1 postgresql_db_t:lnk_file read_lnk_file_perms;
|
|
Chris PeBenito |
17de1b7 |
')
|
|
Chris PeBenito |
17de1b7 |
|
|
Chris PeBenito |
17de1b7 |
########################################
|
|
Chris PeBenito |
17de1b7 |
## <summary>
|
|
Chris PeBenito |
17de1b7 |
## Execute postgresql in the postgresql domain.
|
|
Chris PeBenito |
17de1b7 |
## </summary>
|
|
Chris PeBenito |
17de1b7 |
## <param name="domain">
|
|
Chris PeBenito |
17de1b7 |
## <summary>
|
|
Dominick Grift |
288845a |
## Domain allowed to transition.
|
|
Chris PeBenito |
17de1b7 |
## </summary>
|
|
Chris PeBenito |
17de1b7 |
## </param>
|
|
Chris PeBenito |
17de1b7 |
#
|
|
Chris PeBenito |
17de1b7 |
interface(`postgresql_domtrans',`
|
|
Chris PeBenito |
17de1b7 |
gen_require(`
|
|
Chris PeBenito |
17de1b7 |
type postgresql_t, postgresql_exec_t;
|
|
Chris PeBenito |
17de1b7 |
')
|
|
Chris PeBenito |
17de1b7 |
|
|
Chris PeBenito |
0bfccda |
domtrans_pattern($1, postgresql_exec_t, postgresql_t)
|
|
Chris PeBenito |
17de1b7 |
')
|
|
Chris PeBenito |
17de1b7 |
|
|
Jeremy Solt |
9681df1 |
######################################
|
|
Jeremy Solt |
9681df1 |
## <summary>
|
|
Jeremy Solt |
9681df1 |
## Allow domain to signal postgresql
|
|
Jeremy Solt |
9681df1 |
## </summary>
|
|
Jeremy Solt |
9681df1 |
## <param name="domain">
|
|
Jeremy Solt |
9681df1 |
## <summary>
|
|
Dominick Grift |
288845a |
## Domain allowed access.
|
|
Jeremy Solt |
9681df1 |
## </summary>
|
|
Jeremy Solt |
9681df1 |
## </param>
|
|
Jeremy Solt |
9681df1 |
#
|
|
Jeremy Solt |
9681df1 |
interface(`postgresql_signal',`
|
|
Jeremy Solt |
9681df1 |
gen_require(`
|
|
Jeremy Solt |
9681df1 |
type postgresql_t;
|
|
Jeremy Solt |
9681df1 |
')
|
|
Jeremy Solt |
9681df1 |
allow $1 postgresql_t:process signal;
|
|
Jeremy Solt |
9681df1 |
')
|
|
Jeremy Solt |
9681df1 |
|
|
Chris PeBenito |
17de1b7 |
########################################
|
|
Chris PeBenito |
17de1b7 |
## <summary>
|
|
Chris PeBenito |
17de1b7 |
## Allow the specified domain to read postgresql's etc.
|
|
Chris PeBenito |
17de1b7 |
## </summary>
|
|
Chris PeBenito |
17de1b7 |
## <param name="domain">
|
|
Chris PeBenito |
17de1b7 |
## <summary>
|
|
Chris PeBenito |
17de1b7 |
## Domain allowed access.
|
|
Chris PeBenito |
17de1b7 |
## </summary>
|
|
Chris PeBenito |
17de1b7 |
## </param>
|
|
Chris PeBenito |
bbcd3c9 |
## <rolecap/>
|
|
Chris PeBenito |
17de1b7 |
#
|
|
Chris PeBenito |
17de1b7 |
interface(`postgresql_read_config',`
|
|
Chris PeBenito |
17de1b7 |
gen_require(`
|
|
Chris PeBenito |
17de1b7 |
type postgresql_etc_t;
|
|
Chris PeBenito |
17de1b7 |
')
|
|
Chris PeBenito |
17de1b7 |
|
|
Chris PeBenito |
17de1b7 |
files_search_etc($1)
|
|
Chris PeBenito |
82d2775 |
allow $1 postgresql_etc_t:dir list_dir_perms;
|
|
Chris PeBenito |
82d2775 |
allow $1 postgresql_etc_t:file read_file_perms;
|
|
Chris PeBenito |
82d2775 |
allow $1 postgresql_etc_t:lnk_file read_lnk_file_perms;
|
|
Chris PeBenito |
17de1b7 |
')
|
|
Chris PeBenito |
17de1b7 |
|
|
Chris PeBenito |
17de1b7 |
########################################
|
|
Chris PeBenito |
17de1b7 |
## <summary>
|
|
Chris PeBenito |
0b6acad |
## Allow the specified domain to connect to postgresql with a tcp socket.
|
|
Chris PeBenito |
17de1b7 |
## </summary>
|
|
Chris PeBenito |
17de1b7 |
## <param name="domain">
|
|
Chris PeBenito |
17de1b7 |
## <summary>
|
|
Chris PeBenito |
17de1b7 |
## Domain allowed access.
|
|
Chris PeBenito |
17de1b7 |
## </summary>
|
|
Chris PeBenito |
17de1b7 |
## </param>
|
|
Chris PeBenito |
17de1b7 |
#
|
|
Chris PeBenito |
17de1b7 |
interface(`postgresql_tcp_connect',`
|
|
Chris PeBenito |
0b6acad |
gen_require(`
|
|
Chris PeBenito |
0b6acad |
type postgresql_t;
|
|
Chris PeBenito |
0b6acad |
')
|
|
Chris PeBenito |
0b6acad |
|
|
Chris PeBenito |
0bfccda |
corenet_tcp_recvfrom_labeled($1, postgresql_t)
|
|
Chris PeBenito |
0b6acad |
corenet_tcp_sendrecv_postgresql_port($1)
|
|
Chris PeBenito |
0b6acad |
corenet_tcp_connect_postgresql_port($1)
|
|
Chris PeBenito |
0b6acad |
corenet_sendrecv_postgresql_client_packets($1)
|
|
Chris PeBenito |
17de1b7 |
')
|
|
Chris PeBenito |
17de1b7 |
|
|
Chris PeBenito |
17de1b7 |
########################################
|
|
Chris PeBenito |
17de1b7 |
## <summary>
|
|
Chris PeBenito |
17de1b7 |
## Allow the specified domain to connect to postgresql with a unix socket.
|
|
Chris PeBenito |
17de1b7 |
## </summary>
|
|
Chris PeBenito |
17de1b7 |
## <param name="domain">
|
|
Chris PeBenito |
17de1b7 |
## <summary>
|
|
Chris PeBenito |
17de1b7 |
## Domain allowed access.
|
|
Chris PeBenito |
17de1b7 |
## </summary>
|
|
Chris PeBenito |
17de1b7 |
## </param>
|
|
Chris PeBenito |
17de1b7 |
#
|
|
Chris PeBenito |
17de1b7 |
interface(`postgresql_stream_connect',`
|
|
Chris PeBenito |
17de1b7 |
gen_require(`
|
|
Chris PeBenito |
17de1b7 |
type postgresql_t, postgresql_var_run_t, postgresql_tmp_t;
|
|
Chris PeBenito |
17de1b7 |
')
|
|
Chris PeBenito |
17de1b7 |
|
|
Chris PeBenito |
17de1b7 |
files_search_pids($1)
|
|
Dominick Grift |
ac13ad9 |
files_search_tmp($1)
|
|
Dominick Grift |
2a72457 |
stream_connect_pattern($1, { postgresql_var_run_t postgresql_tmp_t }, { postgresql_var_run_t postgresql_tmp_t }, postgresql_t)
|
|
Chris PeBenito |
17de1b7 |
')
|
|
Chris PeBenito |
e8cb08a |
|
|
Chris PeBenito |
e8cb08a |
########################################
|
|
Chris PeBenito |
e8cb08a |
## <summary>
|
|
Chris PeBenito |
ff8f0a6 |
## Allow the specified domain unprivileged accesses to unifined database objects
|
|
Chris PeBenito |
e8cb08a |
## managed by SE-PostgreSQL,
|
|
Chris PeBenito |
e8cb08a |
## </summary>
|
|
Chris PeBenito |
e8cb08a |
## <param name="domain">
|
|
Chris PeBenito |
ff8f0a6 |
## <summary>
|
|
Chris PeBenito |
ff8f0a6 |
## Domain allowed access.
|
|
Chris PeBenito |
ff8f0a6 |
## </summary>
|
|
Chris PeBenito |
e8cb08a |
## </param>
|
|
Chris PeBenito |
e8cb08a |
#
|
|
Chris PeBenito |
e8cb08a |
interface(`postgresql_unpriv_client',`
|
|
Chris PeBenito |
e8cb08a |
gen_require(`
|
|
Chris PeBenito |
a01a4a7 |
class db_database all_db_database_perms;
|
|
Chris PeBenito |
e8cb08a |
class db_table all_db_table_perms;
|
|
Chris PeBenito |
e8cb08a |
class db_procedure all_db_procedure_perms;
|
|
Chris PeBenito |
a01a4a7 |
class db_column all_db_column_perms;
|
|
Chris PeBenito |
a01a4a7 |
class db_tuple all_db_tuple_perms;
|
|
Chris PeBenito |
e8cb08a |
class db_blob all_db_blob_perms;
|
|
Chris PeBenito |
e8cb08a |
|
|
Chris PeBenito |
e8cb08a |
attribute sepgsql_client_type;
|
|
Chris PeBenito |
a01a4a7 |
attribute sepgsql_database_type, sepgsql_sysobj_table_type;
|
|
Chris PeBenito |
e8cb08a |
|
|
Chris PeBenito |
7f4005e |
type sepgsql_trusted_proc_t, sepgsql_trusted_proc_exec_t;
|
|
Chris PeBenito |
a01a4a7 |
type unpriv_sepgsql_blob_t, unpriv_sepgsql_proc_exec_t;
|
|
Chris PeBenito |
a01a4a7 |
type unpriv_sepgsql_sysobj_t, unpriv_sepgsql_table_t;
|
|
Chris PeBenito |
e8cb08a |
')
|
|
Chris PeBenito |
e8cb08a |
|
|
Chris PeBenito |
a01a4a7 |
########################################
|
|
Chris PeBenito |
a01a4a7 |
#
|
|
Chris PeBenito |
a01a4a7 |
# Declarations
|
|
Chris PeBenito |
a01a4a7 |
#
|
|
Chris PeBenito |
a01a4a7 |
|
|
Chris PeBenito |
e8cb08a |
typeattribute $1 sepgsql_client_type;
|
|
Chris PeBenito |
e8cb08a |
|
|
Chris PeBenito |
a01a4a7 |
########################################
|
|
Chris PeBenito |
a01a4a7 |
#
|
|
Chris PeBenito |
a01a4a7 |
# Client local policy
|
|
Chris PeBenito |
a01a4a7 |
#
|
|
Chris PeBenito |
e8cb08a |
|
|
Chris PeBenito |
7f4005e |
type_transition $1 sepgsql_trusted_proc_exec_t:process sepgsql_trusted_proc_t;
|
|
Chris PeBenito |
7f4005e |
allow $1 sepgsql_trusted_proc_t:process transition;
|
|
Chris PeBenito |
a01a4a7 |
|
|
Chris PeBenito |
a01a4a7 |
allow $1 unpriv_sepgsql_table_t:db_table { getattr use select update insert delete lock };
|
|
Chris PeBenito |
a01a4a7 |
allow $1 unpriv_sepgsql_table_t:db_column { getattr use select update insert };
|
|
Chris PeBenito |
a01a4a7 |
allow $1 unpriv_sepgsql_table_t:db_tuple { use select update insert delete };
|
|
Chris PeBenito |
a01a4a7 |
type_transition $1 sepgsql_database_type:db_table unpriv_sepgsql_table_t;
|
|
Chris PeBenito |
a01a4a7 |
|
|
Chris PeBenito |
a01a4a7 |
allow $1 unpriv_sepgsql_sysobj_t:db_tuple { use select };
|
|
Chris PeBenito |
a01a4a7 |
type_transition $1 sepgsql_sysobj_table_type:db_tuple unpriv_sepgsql_sysobj_t;
|
|
Chris PeBenito |
a01a4a7 |
|
|
Chris PeBenito |
e0ea7b1 |
allow $1 unpriv_sepgsql_proc_exec_t:db_procedure { getattr execute };
|
|
Chris PeBenito |
a01a4a7 |
type_transition $1 sepgsql_database_type:db_procedure unpriv_sepgsql_proc_exec_t;
|
|
Chris PeBenito |
a01a4a7 |
|
|
Chris PeBenito |
996779d |
allow $1 unpriv_sepgsql_blob_t:db_blob { create drop getattr setattr read write import export };
|
|
Chris PeBenito |
a01a4a7 |
type_transition $1 sepgsql_database_type:db_blob unpriv_sepgsql_blob_t;
|
|
Dominick Grift |
b46b3ad |
|
|
Dominick Grift |
b46b3ad |
tunable_policy(`sepgsql_enable_users_ddl',`
|
|
Dominick Grift |
b46b3ad |
allow $1 unpriv_sepgsql_table_t:db_table { create drop setattr };
|
|
Dominick Grift |
b46b3ad |
allow $1 unpriv_sepgsql_table_t:db_column { create drop setattr };
|
|
Dominick Grift |
b46b3ad |
allow $1 unpriv_sepgsql_sysobj_t:db_tuple { update insert delete };
|
|
Dominick Grift |
b46b3ad |
allow $1 unpriv_sepgsql_proc_exec_t:db_procedure { create drop setattr };
|
|
Dominick Grift |
b46b3ad |
')
|
|
Chris PeBenito |
e8cb08a |
')
|
|
Chris PeBenito |
e8cb08a |
|
|
Chris PeBenito |
e8cb08a |
########################################
|
|
Chris PeBenito |
e8cb08a |
## <summary>
|
|
Chris PeBenito |
ff8f0a6 |
## Allow the specified domain unconfined accesses to any database objects
|
|
Chris PeBenito |
e8cb08a |
## managed by SE-PostgreSQL,
|
|
Chris PeBenito |
e8cb08a |
## </summary>
|
|
Chris PeBenito |
e8cb08a |
## <param name="domain">
|
|
Chris PeBenito |
ff8f0a6 |
## <summary>
|
|
Chris PeBenito |
ff8f0a6 |
## Domain allowed access.
|
|
Chris PeBenito |
ff8f0a6 |
## </summary>
|
|
Chris PeBenito |
e8cb08a |
## </param>
|
|
Chris PeBenito |
e8cb08a |
#
|
|
Chris PeBenito |
e8cb08a |
interface(`postgresql_unconfined',`
|
|
Chris PeBenito |
e8cb08a |
gen_require(`
|
|
Chris PeBenito |
e8cb08a |
attribute sepgsql_unconfined_type;
|
|
Chris PeBenito |
e8cb08a |
')
|
|
Chris PeBenito |
e8cb08a |
|
|
Chris PeBenito |
e8cb08a |
typeattribute $1 sepgsql_unconfined_type;
|
|
Chris PeBenito |
e8cb08a |
')
|
|
Chris PeBenito |
22a2874 |
|
|
Chris PeBenito |
22a2874 |
########################################
|
|
Chris PeBenito |
22a2874 |
## <summary>
|
|
Chris PeBenito |
22a2874 |
## All of the rules required to administrate an postgresql environment
|
|
Chris PeBenito |
22a2874 |
## </summary>
|
|
Chris PeBenito |
22a2874 |
## <param name="domain">
|
|
Chris PeBenito |
22a2874 |
## <summary>
|
|
Chris PeBenito |
22a2874 |
## Domain allowed access.
|
|
Chris PeBenito |
22a2874 |
## </summary>
|
|
Chris PeBenito |
22a2874 |
## </param>
|
|
Chris PeBenito |
22a2874 |
## <param name="role">
|
|
Chris PeBenito |
22a2874 |
## <summary>
|
|
Chris PeBenito |
22a2874 |
## The role to be allowed to manage the postgresql domain.
|
|
Chris PeBenito |
22a2874 |
## </summary>
|
|
Chris PeBenito |
22a2874 |
## </param>
|
|
Chris PeBenito |
22a2874 |
## <rolecap/>
|
|
Chris PeBenito |
22a2874 |
#
|
|
Chris PeBenito |
22a2874 |
interface(`postgresql_admin',`
|
|
Chris PeBenito |
22a2874 |
gen_require(`
|
|
Dominick Grift |
2528a2d |
attribute sepgsql_admin_type, sepgsql_client_type;
|
|
Dominick Grift |
2528a2d |
type postgresql_t, postgresql_var_run_t, postgresql_initrc_exec_t;
|
|
Dominick Grift |
2528a2d |
type postgresql_tmp_t, postgresql_db_t, postgresql_log_t;
|
|
Dominick Grift |
2528a2d |
type postgresql_etc_t;
|
|
Chris PeBenito |
22a2874 |
')
|
|
Chris PeBenito |
22a2874 |
|
|
Chris PeBenito |
22a2874 |
typeattribute $1 sepgsql_admin_type;
|
|
Chris PeBenito |
22a2874 |
|
|
Chris PeBenito |
22a2874 |
allow $1 postgresql_t:process { ptrace signal_perms };
|
|
Chris PeBenito |
22a2874 |
ps_process_pattern($1, postgresql_t)
|
|
Chris PeBenito |
22a2874 |
|
|
Chris PeBenito |
22a2874 |
init_labeled_script_domtrans($1, postgresql_initrc_exec_t)
|
|
Chris PeBenito |
22a2874 |
domain_system_change_exemption($1)
|
|
Chris PeBenito |
22a2874 |
role_transition $2 postgresql_initrc_exec_t system_r;
|
|
Chris PeBenito |
22a2874 |
allow $2 system_r;
|
|
Chris PeBenito |
22a2874 |
|
|
Dominick Grift |
ddbd71a |
files_list_pids($1)
|
|
Chris PeBenito |
22a2874 |
admin_pattern($1, postgresql_var_run_t)
|
|
Chris PeBenito |
22a2874 |
|
|
Dominick Grift |
61f4064 |
files_list_var_lib($1)
|
|
Chris PeBenito |
22a2874 |
admin_pattern($1, postgresql_db_t)
|
|
Chris PeBenito |
22a2874 |
|
|
Dominick Grift |
61f4064 |
files_list_etc($1)
|
|
Chris PeBenito |
22a2874 |
admin_pattern($1, postgresql_etc_t)
|
|
Chris PeBenito |
22a2874 |
|
|
Dominick Grift |
61f4064 |
logging_list_logs($1)
|
|
Chris PeBenito |
22a2874 |
admin_pattern($1, postgresql_log_t)
|
|
Chris PeBenito |
22a2874 |
|
|
Dominick Grift |
ddbd71a |
files_list_tmp($1)
|
|
Chris PeBenito |
22a2874 |
admin_pattern($1, postgresql_tmp_t)
|
|
Chris PeBenito |
22a2874 |
|
|
Chris PeBenito |
22a2874 |
postgresql_tcp_connect($1)
|
|
Chris PeBenito |
22a2874 |
postgresql_stream_connect($1)
|
|
Chris PeBenito |
22a2874 |
')
|