DROP OWNED(7) PostgreSQL 9.2.7 Documentation 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
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.
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))
PostgreSQL 9.2.7 2014-02-17 DROP OWNED(7)
Check Out this Related Man Page
REASSIGN OWNED(7) SQL Commands REASSIGN OWNED(7)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 cur-
rent 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 [drop_owned(7)] 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_owned(7)], DROP ROLE [drop_role(7)]
SQL - Language Statements 2010-05-14 REASSIGN OWNED(7)
I have a program which gets an input file (which contain a list of objects) and processes the objects one by one sequentially. However when there are many objects it is faster to split the input into smaller lists and run the program in multiple terminal sessions simultaneously. I want to know if... (2 Replies)
hi freinds,
can someone provide me a good link to unix make utility.
about make i only know that it plays a key role in sotware
development,as it helps in compilation and debugging.
thanks (1 Reply)
Hi everybody,
i need help from all of you.
I have many users who are no more work in our Company. Some who get objects are Locked. There Many users and many Database Servers. And it'll take long for me to finished this job.
That's why i need your help to provide me anyone Scripts... (2 Replies)
A recent job advertisement caught my attention, because I thought I was already broadly familiar with all the major OSes and database engines:
Apparently (according to Wikipedia), ADABAS is an 'inverted list database... described as "Post-relational" but "Relational Like" in its characteristics'... (4 Replies)
Hi,
Using grep how to ignore multiple patterns
for example
# multiple
#installOption
#role
role
#ROLE
I want to ignore all that comes with # in a single command
If I use
grep -v \^\#"role" <filename> (2 Replies)
Hi,
I need a sample script to validate all the database objects like
1. table structure(columns, datatypes,key contraints if any)
2. synonyms
3. grants
4. indexes
....etc
thank you! (2 Replies)
Hi All,
I am working on a file transfer tool between unix servers.
for this i am looking for a small database which is free and compatible with all unix OS and can be bundled in a package with other scripts.
Any suggestions (8 Replies)