Re: CREATEROLE users vs. role properties

Robert Haas <robertmhaas@gmail.com>

From: Robert Haas <robertmhaas@gmail.com>

To: tushar <tushar.ahuja@enterprisedb.com>

Cc: Nathan Bossart <nathandbossart@gmail.com>, "pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>

Date: 2023-01-24T16:00:47Z

Lists: pgsql-hackers

On Tue, Jan 24, 2023 at 9:07 AM tushar <tushar.ahuja@enterprisedb.com> wrote:
> right, Neha/I have tested with different scenarios using createdb/replication/bypassrls and other
> privileges properties on the role. also checked pg_dumpall/pg_basebackup and everything looks fine.

Thanks. I have committed the patch.

-- 
Robert Haas
EDB: http://www.enterprisedb.com

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Improve several permission-related error messages.
- de4d456b406b 16.0 landed
Integrate superuser check into has_rolreplication()
- 442f8700656b 16.0 landed
Small code simplification
- 3b7cd8c690f2 16.0 landed
Adjust interaction of CREATEROLE with role properties.
- f1358ca52dd7 16.0 landed
Add new GUC reserved_connections.
- 6e2775e4d4e4 16.0 landed
Rename ReservedBackends variable to SuperuserReservedConnections.
- fe00fec1f5d7 16.0 landed
Update docs and error message for superuser_reserved_connections.
- 6c1d5ba48678 16.0 landed
Add new GUC createrole_self_grant.
- e5b8a4c098ad 16.0 cited
Restrict the privileges of CREATEROLE users.
- cf5eb37c5ee0 16.0 cited
Add a SET option to the GRANT command.
- 3d14e171e9e2 16.0 cited