Skip to main content

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​

{{< sql-section file="data/sql/users.json" data="alterUserParameters" >}}

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