Postgres Enhancement Request

From: "Zwettler Markus (OIZ)" <Markus(dot)Zwettler(at)zuerich(dot)ch>
To: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Postgres Enhancement Request
Date: 2019-03-20 10:10:04
Message-ID: de9a4bb5fc70414caa68330aef5f843b@zuerich.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

CREATEROLE allows users to create new roles also having the CREATEDB privilege (at least in version 9.6).

We want special users to be able to CREATEROLE without being able to CREATEDB (eg. when usermanagement is done by the application itself).

Please prevent users with CREATEROLE to create roles having CREATEDB (analogous SUPERUSER and REPLICATION).

Thanks

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Kellerer 2019-03-20 10:44:38 Re: Postgres Enhancement Request
Previous Message Thomas Munro 2019-03-20 06:31:58 Re: FreeBSD 12 and Postgres build failures