is often used to prepare for the removal of one or more roles. Because
only affects the objects in the current database, it is usually necessary to execute this command in each database that contains objects owned by a role that is to be removed.
option might make the command recurse to objects owned by other users.
REASSIGN OWNED (REASSIGN_OWNED(7))
command is an alternative that reassigns the ownership of all the database objects owned by one or more roles. However,
does not deal with privileges for other objects.
Databases and tablespaces owned by the role(s) will not be removed.
Section 20.4, Dropping Roles, in the documentation
for more discussion.