Notes
DROP OWNED is often used to prepare for the
removal of one or more roles. Because DROP OWNED
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.
Using the CASCADE option may make the command
recurse to objects owned by other users.
The REASSIGN OWNED command is an alternative that
reassigns the ownership of all the database objects owned by one or
more roles.