drop_owned man page on Debian

Man page or keyword search:  
man Server   8174 pages
apropos Keyword Search (all sections)
Output format
Debian logo
[printable version]

DROP OWNED(7)			 SQL Commands			 DROP OWNED(7)

NAME
       DROP OWNED - remove database objects owned by a database role

SYNOPSIS
       DROP OWNED BY name [, ...] [ CASCADE | RESTRICT ]

DESCRIPTION
       DROP  OWNED  drops all the objects within the current database that are
       owned by one of the specified roles.  Any  privileges  granted  to  the
       given  roles  on	 objects in the current database and on shared objects
       (databases, tablespaces) will also be revoked.

PARAMETERS
       name   The name of a role whose objects	will  be  dropped,  and	 whose
	      privileges will be revoked.

       CASCADE
	      Automatically drop objects that depend on the affected objects.

       RESTRICT
	      Refuse to drop the objects owned by a role if any other database
	      objects depend on one of	the  affected  objects.	 This  is  the
	      default.

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 data‐
       base,  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 might make  the	 command  recurse  to  objects
       owned by other users.

       The  REASSIGN  OWNED [reassign_owned(7)] command is an alternative that
       reassigns the ownership of all the database objects  owned  by  one  or
       more roles.

       Databases and tablespaces owned by the role(s) will not be removed.

COMPATIBILITY
       The DROP OWNED statement is a PostgreSQL extension.

SEE ALSO
       REASSIGN OWNED [reassign_owned(7)], DROP ROLE [drop_role(7)]

SQL - Language Statements	  2013-04-02			 DROP OWNED(7)
[top]

List of man pages available for Debian

Copyright (c) for man pages and the logo by the respective OS vendor.

For those who want to learn more, the polarhome community provides shell access and support.

[legal] [privacy] [GNU] [policy] [cookies] [netiquette] [sponsors] [FAQ]
Tweet
Polarhome, production since 1999.
Member of Polarhome portal.
Based on Fawad Halim's script.
....................................................................
Vote for polarhome
Free Shell Accounts :: the biggest list on the net