Skip to main content

Users

User management may be performed using SQL commands. To add a role to a user, use the associated ROLE SQL command.

Creating a User​

Create user syntax
CREATE USER <username>

Parameters​

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

Examples​

Create a user
CREATE USER "user@dremio.com"

Altering a User Password​

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.

Alter user password syntax
-- Set a new password
ALTER USER <username> SET PASSWORD `<password>` 
-- Remove the existing password
ALTER USER <username> UNSET PASSWORD

Parameters​

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

Examples​

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

Dropping a User​

warning:

When dropping an external user from Dremio, this does not prevent them from accessing Dremio again. The next time that user logs in on Dremio using their external credential manager, a new account is created for them in Dremio automatically.

Drop user syntax
DROP USER <username>

Parameters​

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

Example​

Dropping a local user
DROP USER "user@dremio.com"