From: | Erik Wienhold <ewie(at)ewie(dot)name> |
---|---|
To: | Koen De Groote <kdg(dot)dev(at)gmail(dot)com>, pgsql-admin(at)lists(dot)postgresql(dot)org |
Subject: | Re: Completely replacing an old user |
Date: | 2023-09-16 20:37:30 |
Message-ID: | 495059484.82333.1694896650450@office.mailbox.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On 16/09/2023 20:27 CEST Koen De Groote <kdg(dot)dev(at)gmail(dot)com> wrote:
> I am trying to set up a new user for a client application, and thus want to
> remove the old user afterward.
>
> But I'm getting stuck on one last error message:
>
> ERROR: role "X" cannot be dropped because some objects depend on it
> DETAIL: privileges for default privileges on new functions belonging to
> role postgres in schema public
You must also revoke its default privileges before you can drop a role.
That's mentioned in the notes of ALTER DEFAULT PRIVILEGES [1].
> The "new functions" bit is confusing. I've swapped over all the current
> functions, but cannot seem to find the appropriate table for privileges on
> new functions.
psql command \ddp will show you the default privileges.
[1] https://www.postgresql.org/docs/16/sql-alterdefaultprivileges.html#SQL-ALTERDEFAULTPRIVILEGES-NOTES
--
Erik
From | Date | Subject | |
---|---|---|---|
Next Message | David G. Johnston | 2023-09-16 22:45:48 | Re: Completely replacing an old user |
Previous Message | Koen De Groote | 2023-09-16 18:27:18 | Completely replacing an old user |