|PostgreSQL Reference Manual - Volume 1 - SQL Language Reference|
by The PostgreSQL Global Development Group
Paperback (6"x9"), 716 pages
RRP £32.00 ($49.95)
Sales of this book support the PostgreSQL project! Get a printed copy>>>
12.90 REASSIGN OWNED
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
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.
DROP OWNED command is an alternative that
drops all the database objects owned by one or more roles.
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
REASSIGN OWNED statement is a
|ISBN 0954612027||PostgreSQL Reference Manual - Volume 1 - SQL Language Reference||See the print edition|