# REASSIGN_OWNED - change the ownership of database objects owned by a da... - man(7) - [phpMan]

_REASSIGN_ [_OWNED_(7)](https://www.chedong.com/phpMan.php/man/OWNED/7/markdown)                  PostgreSQL 16.14 Documentation                  _REASSIGN_ [_OWNED_(7)](https://www.chedong.com/phpMan.php/man/OWNED/7/markdown)

## NAME
       REASSIGN_OWNED - change the ownership of database objects owned by a database role

## SYNOPSIS
       REASSIGN OWNED BY { _old_role_ | CURRENT_ROLE | CURRENT_USER | SESSION_USER } [, ...]
                      TO { _new_role_ | CURRENT_ROLE | CURRENT_USER | SESSION_USER }

## DESCRIPTION
       **REASSIGN OWNED **instructs the system to change the ownership of database objects owned by any
       of the _old_roles_ to _new_role_.

## PARAMETERS
       _old_role_
           The name of a role. The ownership of all the objects within the current database, and of
           all shared objects (databases, tablespaces), owned by this role will be reassigned to
           _new_role_.

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

## NOTES
       **REASSIGN OWNED **is often used to prepare for the removal of one or more roles. Because
       **REASSIGN OWNED **does not affect objects within other databases, it is usually necessary to
       execute this command in each database that contains objects owned by a role that is to be
       removed.

       **REASSIGN OWNED **requires membership on both the source role(s) and the target role.

       The **DROP OWNED **command is an alternative that simply drops all the database objects owned by
       one or more roles.

       The **REASSIGN OWNED **command does not affect any privileges granted to the _old_roles_ on objects
       that are not owned by them. Likewise, it does not affect default privileges created with
       **ALTER DEFAULT PRIVILEGES**. Use **DROP OWNED **to revoke such privileges.

       See Section 22.4 for more discussion.

## COMPATIBILITY
       The **REASSIGN OWNED **command is a PostgreSQL extension.

## SEE ALSO
       DROP OWNED ([**DROP_OWNED**(7)](https://www.chedong.com/phpMan.php/man/DROPOWNED/7/markdown)), DROP ROLE ([**DROP_ROLE**(7)](https://www.chedong.com/phpMan.php/man/DROPROLE/7/markdown)), ALTER DATABASE ([**ALTER_DATABASE**(7)](https://www.chedong.com/phpMan.php/man/ALTERDATABASE/7/markdown))

PostgreSQL 16.14                                2026                               _REASSIGN_ [_OWNED_(7)](https://www.chedong.com/phpMan.php/man/OWNED/7/markdown)