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 <[email protected]> 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 <[email protected] >> <mailto:[email protected]>> 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? >>
