On Wed, Jan 25, 2023 at 7:35 AM Bruce Momjian <br...@momjian.us> wrote:

>
> So, how would someone with CREATEROLE permission add people to their own
> role, without superuser permission?  Are we adding any security by
> preventing this?
>
>
As an encouraged design choice you wouldn't.  You'd create a new group and
add both yourself and the new role to it - then grant it the desired
permissions.

A CREATEROLE role should probably be a user (LOGIN) role and user roles
should not have members.

David J.

Reply via email to