Enable the postgresql_selinux_users_ddl SELinux Boolean

An XCCDF Rule

Description

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

$ sudo setsebool -P postgresql_selinux_users_ddl on

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

- name: Enable the postgresql_selinux_users_ddl 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_users_ddl
- name: XCCDF Value var_postgresql_selinux_users_ddl # promote to variable
  set_fact:
    var_postgresql_selinux_users_ddl: !!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_users_ddl" use="legacy"/>
  tags:
    - always

- name: Enable the postgresql_selinux_users_ddl SELinux Boolean - Set SELinux Boolean
    postgresql_selinux_users_ddl Accordingly
  seboolean:
    name: postgresql_selinux_users_ddl
    state: '{{ var_postgresql_selinux_users_ddl }}'
    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_users_ddl

# 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_users_ddl='<xccdf-1.2:sub xmlns:xccdf-1.2="http://checklists.nist.gov/xccdf/1.2" idref="xccdf_org.ssgproject.content_value_var_postgresql_selinux_users_ddl" use="legacy"/>'

    setsebool -P postgresql_selinux_users_ddl $var_postgresql_selinux_users_ddl

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

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

Enable the postgresql_selinux_users_ddl SELinux Boolean

Description

Remediation - Ansible

Remediation - Shell Script