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