-- Removes an user account information
DROP USER username
The name of an existing user.
The message returned if the user is successfully deleted.
- ERROR: removeUser: user "username" does not exist.
This message occurs if the username is not found.
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.
DROP USER is a Postgres
Refer to CREATE USER and
ALTER USER for information on
how to create or modify user accounts.
To drop a user account:
DROP USER Jonathan;
There is no DROP USER in SQL92.