Re: Completely replacing an old user - Mailing list pgsql-admin

From David G. Johnston
Subject Re: Completely replacing an old user
Date
Msg-id CAKFQuwZo1WcQUm3cruboPv=8h51G0kGAkRTVDnEGh+XOkgnnFQ@mail.gmail.com
Whole thread Raw
In response to Completely replacing an old user  (Koen De Groote <kdg.dev@gmail.com>)
List pgsql-admin


On Saturday, September 16, 2023, Koen De Groote <kdg.dev@gmail.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…


David J.

pgsql-admin by date:

Previous
From: Erik Wienhold
Date:
Subject: Re: Completely replacing an old user
Next
From: Pepe TD Vo
Date:
Subject: Re: Completely replacing an old user