Re: revoke default privileges on schema for role of original grantor

Hi Alain,

Please raise a feature request here -
https://redmine.postgresql.org/projects/pgadmin4/issues/new

On Tue, Jan 4, 2022 at 10:35 PM Remund Alain <alain(dot)remund(at)bertschi(dot)com>
wrote:

> Hi all
>
>
>
> We are using the current pgAdmin version 6.3 extensively and are super
> happy with it. Thanks a lot to everyone who is involved and works so hard
> on this product.
>
>
>
> Recently, we wanted to delete default privileges on a schema. (Right click
> on the schema à Properties… à Default privileges à klick on garbage bin
> icon). This produces the following SQL-statement:
>
>
>
> ALTER DEFAULT PRIVILEGES IN SCHEMA <schema>
>
> REVOKE ALL ON TABLES FROM <user>;
>
>
>
> This works fine if the default privileges were granted by the currently
> logged in user. As we can see in the documentation
> https://www.postgresql.org/docs/current/sql-alterdefaultprivileges.html ,
> if “FOR ROLE” is omitted, the current role is assumed.
>
> However, if the default privileges were granted by another user, this
> statement does not have any effect (because there are no default privileges
> to be revoked which were granted by the currently logged in user). In my
> opinion, the following statement is supposed to be generated:
>
>
>
> ALTER DEFAULT PRIVILEGES FOR ROLE <original grantor> IN SCHEMA <schema>
>
> REVOKE ALL ON TABLES FROM <user>;
>
>
>
>
>
> Of course we have perfectly valid workaround by just altering the
> statement as described and executing it manually. I just wanted to bring
> this up since it would be nice to be fixed.
>
>
>
> Again, tanks for all the work you guys pour into pgAdmin.
>
> Regards,
>
> Alain Remund
>

--
Thanks,
Aditya Toshniwal
pgAdmin Hacker | Software Architect | *edbpostgres.com*
<http://edbpostgres.com>
"Don't Complain about Heat, Plant a TREE"