Provided by: postgresql-client-8.4_8.4.11-1_i386 bug

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 in 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 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
       database, 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.

COMPATIBILITY

       The DROP OWNED statement is a PostgreSQL extension.

SEE ALSO

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