Creating a UserCreate user syntax
CREATE USER <username>
Specify the email of the user you're creating. This will be username used to login to Dremio. Enclose the email in double quotes.
ExamplesCreate a user
CREATE USER "firstname.lastname@example.org"
Altering a User Password
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
The username associated with the account you are changing. Enclose the username in double quotes.
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.
The new password for the specified username. The user must now use this password to authenticate to Dremio.
ExamplesSet a new password for an existing user
ALTER USER "email@example.com" SET PASSWORD 'password123'
ALTER USER "firstname.lastname@example.org" UNSET PASSWORD
Dropping a User
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>
The username for the user you want to delete. Enclose the username in double quotes.
ExampleDropping a local user
DROP USER "email@example.com"