Man Pages

reassign_owned(7) - phpMan reassign_owned(7) - phpMan

Command: man perldoc info search(apropos)  

REASSIGN OWNED(7)                SQL Commands                REASSIGN OWNED(7)

       REASSIGN OWNED - change the ownership of database objects owned by a database role

       REASSIGN OWNED BY old_role [, ...] TO new_role

       REASSIGN  OWNED  instructs  the  system  to  change  the  ownership of the database objects owned by one of the
       old_roles, to new_role.

              The name of a role. The ownership of all the objects in the current database owned by this role will  be
              reassigned to new_role.

              The name of the role that will be made the new owner of the affected objects.

       REASSIGN  OWNED  is  often  used  to  prepare for the removal of one or more roles. Because REASSIGN 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.

       The  DROP  OWNED  [drop_owned(7)] command is an alternative that drops all the database objects owned by one or
       more roles.

       The REASSIGN OWNED command does not affect the privileges granted to the old_roles  in  objects  that  are  not
       owned by them. Use DROP OWNED to revoke those privileges.

       The REASSIGN OWNED statement is a PostgreSQL extension.

       DROP OWNED [drop_owned(7)], DROP ROLE [drop_role(7)]

SQL - Language Statements         2014-02-17                 REASSIGN OWNED(7)