| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | Koen De Groote <kdg(dot)dev(at)gmail(dot)com> |
| Cc: | "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Completely replacing an old user |
| Date: | 2023-09-16 22:45:48 |
| Message-ID: | CAKFQuwZo1WcQUm3cruboPv=8h51G0kGAkRTVDnEGh+XOkgnnFQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Saturday, September 16, 2023, Koen De Groote <kdg(dot)dev(at)gmail(dot)com> wrote:
>
>
>
> 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
>
> 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.
>
>
> What am I missing here?
>
Alter default privileges.
And…
https://www.postgresql.org/docs/current/catalog-pg-default-acl.html
David J.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pepe TD Vo | 2023-09-16 22:46:13 | Re: Completely replacing an old user |
| Previous Message | Erik Wienhold | 2023-09-16 20:37:30 | Re: Completely replacing an old user |