Please use the form below to provide your feedback. Because your feedback is valuable to us, the information you submit in this form is recorded in our issue tracking system (JIRA), which is publicly available. You can track the status of your feedback using the ticket number displayed in the dialog once you submit the form.

DROP USER

  • reference
  • Couchbase Server 8.0
    +
    The DROP USER statement enables you to delete a user.

    This statement permanently removes a user from the Couchbase Server Role-Based Access Control (RBAC) system. It removes the user from all groups and revokes all roles and privileges assigned to that user.

    RBAC Privileges

    To execute the DROP USER statement, you must have either the Full Admin or the Security Admin role. For more information about user roles, see Authorization.

    Syntax

    drop-user ::= 'DROP' 'USER' ( 'IF' 'EXISTS' )? username
    Syntax diagram: refer to source code listing
    username

    (Required) The unique identifier of the local user you want to delete.

    IF EXISTS Clause

    The optional IF EXISTS clause enables the statement to complete successfully when the specified user doesn’t exist. If a user with the same username does not exist, then:

    • If this clause is not present, an error is generated.

    • If this clause is present, the statement does nothing and completes without error.

    Examples

    Example 1. Delete a user named Bob
    DROP USER Bob;
    Example 2. Delete a user named David if they exist
    DROP USER IF EXISTS David;