drop_owned man page on UnixWare

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

DROP OWNED()			 SQL Commands			  DROP OWNED()

       DROP OWNED - remove database objects owned by a database role

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

       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.

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

	      Automatically drop objects that depend on the affected objects.

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

       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 may make the command recurse to objects owned
       by other users.

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

       The DROP OWNED statement is a PostgreSQL extension.

       REASSIGN OWNED [reassign_owned(5)], DROP ROLE [drop_role(l)]

SQL - Language Statements	  2008-01-03			  DROP OWNED()
                             _         _         _ 
                            | |       | |       | |     
                            | |       | |       | |     
                         __ | | __ __ | | __ __ | | __  
                         \ \| |/ / \ \| |/ / \ \| |/ /  
                          \ \ / /   \ \ / /   \ \ / /   
                           \   /     \   /     \   /    
                            \_/       \_/       \_/ 
More information is available in HTML format for server UnixWare

List of man pages available for UnixWare

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]
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