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 syntaxCREATE USER <username>
Parameters
<username>
String
Specify the email of the user you're creating. This will be username used to login to Dremio. Enclose the email in double quotes.
Examples
Create a userCREATE 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.
-- Set a new password
ALTER USER <username> SET PASSWORD <password>
-- Remove the existing password
ALTER USER <username> UNSET 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
Set a new password for an existing userALTER USER "user@dremio.com" SET PASSWORD 'password123'
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 <username>
Parameters
<username>
String
The username for the user you want to delete. Enclose the username in double quotes.
Example
Dropping a local userDROP USER "user@dremio.com"