Managing Users
DROP USER
Remove an existing user.
Synopsis
Description
The DROP USER command removes an existing user from the database.
If there is currently a connection to the database by the given user it will be terminated and all running transactions on that connection will be aborted.
Notes:
- A user can remove itself.
- If there is only one user, it cannot be removed.
Parameters
user_name
The name of the user to remove.
Examples
Remove a user:
Compatibility
The DROP USER statement is a Regatta extension as there is no SQL standard for managing users.