Re: BUG #18350: Modifying predefined roles' unlimited connections for VA STIG cybersecurity checklist - Mailing list pgsql-bugs

From David G. Johnston
Subject Re: BUG #18350: Modifying predefined roles' unlimited connections for VA STIG cybersecurity checklist
Date
Msg-id CAKFQuwYuOhaMMxvfVOwJn12BOnOpSS4qEbUQYrJ+8B19zSG0Xw@mail.gmail.com
Whole thread Raw
In response to BUG #18350: Modifying predefined roles' unlimited connections for VA STIG cybersecurity checklist  (PG Bug reporting form <noreply@postgresql.org>)
List pgsql-bugs
On Fri, Feb 16, 2024 at 2:23 PM PG Bug reporting form <noreply@postgresql.org> wrote:
The following bug has been logged on the website:

Bug reference:      18350
Logged by:          Martin Nguyen
Email address:      martin.nguyen@oracle.com
PostgreSQL version: 13.7
Operating system:   RHEL
Description:       

We have identified an issue where predefined roles are not modifiable,
however a Dept. of VA security checklist requires that no roles have
unlimited connections. The Predefined roles have unlimited connections, is
there a way to modify these?


Pre-defined roles do not have the login attribute so the number of connections attribute is irrelevant.

Superusers are not so constrained.

David J.

pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #18350: Modifying predefined roles' unlimited connections for VA STIG cybersecurity checklist
Next
From: Tom Lane
Date:
Subject: Re: BUG #18350: Modifying predefined roles' unlimited connections for VA STIG cybersecurity checklist