Enable the postgresql_selinux_unconfined_dbadm SELinux Boolean

An XCCDF Rule

Description

By default, the SELinux boolean postgresql_selinux_unconfined_dbadm is enabled. If this setting is disabled, it should be enabled as it allows Database Administrators to execute Data Manipulation Language (DML) statements. To enable the postgresql_selinux_unconfined_dbadm SELinux boolean, run the following command:

$ sudo setsebool -P postgresql_selinux_unconfined_dbadm on

ID: xccdf_org.ssgproject.content_rule_sebool_postgresql_selinux_unconfined_dbadm
Severity: Medium
Updated: about 1 year ago

- name: Enable the postgresql_selinux_unconfined_dbadm SELinux Boolean - Ensure python3-libsemanage
    Installed
  package:
    name: python3-libsemanage
    state: present
  when: ansible_virtualization_type not in ["docker", "lxc", "openvz", "podman", "container"]  tags:
  - enable_strategy
  - low_complexity
  - low_disruption
  - medium_severity
  - no_reboot_needed
  - sebool_postgresql_selinux_unconfined_dbadm
- name: XCCDF Value var_postgresql_selinux_unconfined_dbadm # promote to variable
  set_fact:
    var_postgresql_selinux_unconfined_dbadm: !!str <xccdf-1.2:sub xmlns:xccdf-1.2="http://checklists.nist.gov/xccdf/1.2" idref="xccdf_org.ssgproject.content_value_var_postgresql_selinux_unconfined_dbadm" use="legacy"/>
  tags:
    - always

- name: Enable the postgresql_selinux_unconfined_dbadm SELinux Boolean - Set SELinux
    Boolean postgresql_selinux_unconfined_dbadm Accordingly
  seboolean:
    name: postgresql_selinux_unconfined_dbadm
    state: '{{ var_postgresql_selinux_unconfined_dbadm }}'
    persistent: true
  when:
  - ansible_virtualization_type not in ["docker", "lxc", "openvz", "podman", "container"]
  - ansible_facts.selinux.status == 'enabled'
  tags:
  - enable_strategy
  - low_complexity
  - low_disruption
  - medium_severity
  - no_reboot_needed
  - sebool_postgresql_selinux_unconfined_dbadm

# Remediation is applicable only in certain platforms
if [ ! -f /.dockerenv ] && [ ! -f /run/.containerenv ]; then

if ! rpm -q --quiet "python3-libsemanage" ; then
    yum install -y "python3-libsemanage"
fi

if selinuxenabled; then

    var_postgresql_selinux_unconfined_dbadm='<xccdf-1.2:sub xmlns:xccdf-1.2="http://checklists.nist.gov/xccdf/1.2" idref="xccdf_org.ssgproject.content_value_var_postgresql_selinux_unconfined_dbadm" use="legacy"/>'

    setsebool -P postgresql_selinux_unconfined_dbadm $var_postgresql_selinux_unconfined_dbadm

else
    echo "Skipping remediation, SELinux is disabled";
    false
fi

else
    >&2 echo 'Remediation is not applicable, nothing was done'
fi

Enable the postgresql_selinux_unconfined_dbadm SELinux Boolean

Description

Remediation - Ansible

Remediation - Shell Script