DROP USER
SQL - Language Statements
DROP USER
Removes an user account information
1998-09-22
DROP USER name
1998-09-22
Inputs
name
The name of an existing user.
1998-09-22
Outputs
DROP
The message returned if the user is successfully deleted.
ERROR: removeUser: user "name" does not exist.
This message occurs if the username is not found.
1998-09-22
Description
DROP USER removes the specified
user from the database,
along with any databases owned by the user. It
does not remove tables, views, or triggers owned by the
named user in databases not owned by the user. This statement
can be used in place of the destroyuser
script, regardless of how the user was created.
1998-09-22
Notes
DROP USER is a Postgres
language extension.
Refer to CREATE USER and
ALTER USER for information on
how to create or modify user accounts.
Usage
To drop a user account:
DROP USER Jonathan;
Compatibility
1998-09-22
SQL92
There is no DROP USER in SQL92.