On Thu, Jan 19, 2023 at 6:15 AM tushar <tushar.ah...@enterprisedb.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