PostgreSQL 8.4.7 Documentation
Prev | Fast Backward |  | Fast Forward | Next

# REASSIGN OWNED

## Name

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

## Synopsis

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

## Description

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

## Parameters

`old_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`.

`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` 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 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.

## Compatibility

The `REASSIGN OWNED` statement is a PostgreSQL extension.

## See Also

DROP OWNED, DROP ROLE

Prev | Home | Next
PREPARE TRANSACTION | Up | REINDEX