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.

ALTER USER

  • reference
  • Couchbase Server 8.0
    +
    The ALTER USER statement enables you to alter the details of an existing user.

    Purpose

    Use the ALTER USER statement to update a local user’s attributes, such as their password, full name, and group. You can add the user to new groups or remove them from all existing groups.

    This statement helps manage access control and keeps user information up to date within Couchbase Server.

    When you add new groups to a user, the ALTER USER statement replaces the user’s existing group assignments with the new ones you provide. It updates the entire group list, so any existing groups not included in the new list will be removed.

    RBAC Privileges

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

    Syntax

    alter-user ::= 'ALTER' 'USER' username ( 'PASSWORD' password )? 
                ( 'WITH' name )? 
                ( 'GROUP' group | 'GROUPS' group ( ',' group )* | 'NO' 'GROUPS' )?
    Syntax diagram: refer to source code listing
    username

    (Required) The unique identifier of the local user.
    password

    (Optional) A quoted string containing the user’s new password. It must be at least 6 characters long.
    name

    (Optional) A quoted string containing the user’s updated name.
    group

    (Optional) The group you want to assign the user to.

    When altering a user, you can update their group using one of the following options: GROUP, GROUPS, or NO GROUPS. You can specify only one of these options per statement.

    • GROUP assigns the user to a single group.

    • GROUPS assigns the user to multiple groups (the names must be separated by commas).

    • NO GROUPS removes the user from all groups.

    Examples

    Example 1. Change a user’s password and full name
    ALTER USER Hilary PASSWORD "newpassword" WITH "Hilary Chloe";
    Example 2. Assign a user to a new group
    ALTER USER Alice GROUP support;
    Example 3. Remove a user from existing groups
    ALTER USER Bob NO GROUPS;