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
DROP ROLE(7) SQL Commands DROP ROLE(7)NAME
DROP ROLE - remove a database role
SYNOPSIS
DROP ROLE [ IF EXISTS ] name [, ...]
DESCRIPTION
DROP ROLE removes the specified role(s). To drop a superuser role, you must be a superuser yourself; to drop non-superuser roles, you must
have CREATEROLE privilege.
A role cannot be removed if it is still referenced in any database of the cluster; an error will be raised if so. Before dropping the role,
you must drop all the objects it owns (or reassign their ownership) and revoke any privileges the role has been granted. The REASSIGN OWNED
[reassign_owned(7)] and DROP OWNED [drop_owned(7)] commands can be useful for this purpose.
However, it is not necessary to remove role memberships involving the role; DROP ROLE automatically revokes any memberships of the target
role in other roles, and of other roles in the target role. The other roles are not dropped nor otherwise affected.
PARAMETERS
IF EXISTS
Do not throw an error if the role does not exist. A notice is issued in this case.
name The name of the role to remove.
NOTES
PostgreSQL includes a program dropuser [dropuser(1)] that has the same functionality as this command (in fact, it calls this command) but
can be run from the command shell.
EXAMPLES
To drop a role:
DROP ROLE jonathan;
COMPATIBILITY
The SQL standard defines DROP ROLE, but it allows only one role to be dropped at a time, and it specifies different privilege requirements
than PostgreSQL uses.
SEE ALSO
CREATE ROLE [create_role(7)], ALTER ROLE [alter_role(7)], SET ROLE [set_role(7)]
SQL - Language Statements 2010-05-14 DROP ROLE(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)