More fully: REASSIGN OWNED BY doomed_role TO successor_role; DROP OWNED BY doomed_role; -- repeat the above commands in each database of the cluster DROP ROLE doomed_role;
> On Apr 2, 2020, at 20:37 , Guyren Howe <guy...@gmail.com> wrote: > > https://www.postgresql.org/docs/12/sql-drop-owned.html > <https://www.postgresql.org/docs/12/sql-drop-owned.html> > >> On Apr 2, 2020, at 20:34 , AC Gomez <ant...@gmail.com >> <mailto:ant...@gmail.com>> wrote: >> >> Do I understand correctly that if a role was assigned countless object >> privileges and you want to delete that role you have to sift through a >> myriad of privilege grants in what amounts to a time consuming trial and >> error exercise until you've got them all? >> >> Or is there a single command that with just delete the role and do a blanket >> grant removal at the same time? >>
