Dremio Cloud
Dremio Software
 
On this page

    ALTER USER

    Set a new password for an existing user or changes a local user to an external user.

    Syntax 
    ALTER USER <username>
{ SET | UNSET } PASSWORD <password>

    Parameters

    <username>

    String

    The username associated with the account you are changing. Enclose the username in double quotes.

    UNSET PASSWORD <password>

    String

    The username associated with the account you are changing to an external user. This removes the account's existing password and prevents the user from accessing Dremio until an external identity provider grants them access to the service once more.

    SET PASSWORD <password>

    String

    The new password for the specified username. The user must now use this password to authenticate to Dremio.

    Examples

    warning:

    If you’re trying to set a password for an external user via the ALTER USER command, Dremio will return with an error message. Password changes may not be done from Dremio for external users.

    Set a new password for an existing user 
    ALTER USER "user@dremio.com"
SET PASSWORD 'password123'
    Change a local user to an external user 
    ALTER USER "user@dremio.com"
UNSET PASSWORD