> -----Ursprüngliche Nachricht----- > Von: Laurenz Albe <laurenz.albe@xxxxxxxxxxx> > Gesendet: Sonntag, 12. April 2020 22:09 > An: Andrus <kobruleht2@xxxxxx>; pgsql-general <pgsql-general@xxxxxxxxxxxxxx> > Betreff: Re: Which commands are guaranteed to drop role > > On Sun, 2020-04-12 at 00:25 +0300, Andrus wrote: > > User "currentuser" tries to delete role "roletodelete" from this > > database using > > > > But got error > > > > ERROR: role "roletodelete" cannot be dropped because some objects > > depend on it > > DETAIL: privileges for schema public; > > > > How to create script which is guaranteed to delete role ? > > You cannot write such a script, but you will have to REVOKE and change > ownership and ALTER DEFAULT PRIVILEGES until no more dependencies on the > role exist. > > That is why you are well advised not to grant permissions to a role that you plan to > drop. > > Yours, > Laurenz Albe > -- > Cybertec | https://www.cybertec-postgresql.com > > Is there a query to get all missing privileges not revoked yet? Markus
