DROP USER
Description
DROP USER deletes users in GaussDB. This permission can be executed only when you have the permission to create users. After the command for deleting a user is executed successfully, the schema with the same name is deleted.
Precautions
- CASCADE is used to delete the objects (excluding databases) that depend on the user. It cannot delete locked objects unless the objects are unlocked or the threads locking the objects are terminated.
- If the dependent objects are other databases or reside in other databases, manually delete them before deleting the user from the current database. DROP USER cannot delete objects across databases.
- Before deleting a user, you need to delete all the objects owned by the user and revoke the user's permissions on other objects. Alternatively, you can specify CASCADE to delete the objects owned by the user and the granted permissions.
- In a multi-tenant scenario, the service user will also be deleted when you delete a user group. If you want to use CASCADE, set CASCADE for the service user as well. If any error is reported for one user, other users cannot be deleted either.
- If the user has an error table specified when the GDS foreign table is created, the user cannot be deleted by specifying the CASCADE keyword in the DROP USER statement.
Syntax
DROP USER [ IF EXISTS ] user_name [, ...] [ CASCADE | RESTRICT ];
Parameters
- IF EXISTS
When this parameter is used, if the specified user does not exist, a notice instead of an error is sent. Therefore, this parameter can be used to avoid errors.
- user_name
Specifies the name of the user to be deleted.
Value range: an existing username in the database.
- CASCADE | RESTRICT
- CASCADE: automatically deletes objects that depend on the user and revokes the permissions granted to the user.
- RESTRICT: refuses to delete the user if any objects depend on it. This is the default action.
In GaussDB, the enable_kill_query configuration parameter exists in the gaussdb.conf file. This parameter affects CASCADE.
- If enable_kill_query is on and CASCADE is used, the statement automatically kills the threads locking dependent objects and then deletes the specified user.
- If enable_kill_query is off and CASCADE is used, the statement waits until the threads locking dependent objects end and then deletes the specified user.
Examples
-- Create user jim whose login password is ********. gaussdb=# CREATE USER jim PASSWORD '********'; -- Delete user tom that does not exist. gaussdb=# DROP USER IF EXISTS tom; NOTICE: role "tom" does not exist, skipping DROP ROLE -- Delete the user. gaussdb=# DROP USER jim CASCADE;
Helpful Links
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot