V-261898
Crunchy Data Postgres 16 Security Technical Implementation Guide
Title
PostgreSQL must separate user functionality (including user interface services) from database management functionality.
Description
<VulnDiscussion>Information system management functionality includes functions necessary to administer databases, network components, workstations, or servers and typically requires privileged user access. The separation of user functionality from information system management functionality is either physical or logical and is accomplished by using different computers, different central processing units, different instances of the operating system, different network addresses, combinations of t...
Fix Text (Documentation Requirement)
Configure PostgreSQL to separate database administration and general user functionality. Do not grant superuser, create role, create db, or bypass rls role attributes to users that do not require it. To remove privileges, refer to the following example: ALTER ROLE <username> NOSUPERUSER NOCREATEDB NOCREATEROLE NOBYPASSRLS;