On Thu, Jan 19, 2023 at 6:15 AM tushar <tushar(dot)ahuja(at)enterprisedb(dot)com> wrote:
> postgres=# create role fff with createrole;
> CREATE ROLE
> postgres=# create role xxx;
> CREATE ROLE
> postgres=# set role fff;
> SET
> postgres=> alter role xxx with createrole;
> ERROR: permission denied
> postgres=>
Here fff would need ADMIN OPTION on xxx to be able to make modifications to it.
See https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=cf5eb37c5ee0cc54c80d95c1695d7fca1f7c68cb
--
Robert Haas
EDB: http://www.enterprisedb.com