On this page

    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

    Syntax
    CREATE 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 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.

    Syntax
    -- 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.


    <username> UNSET 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 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.

    Syntax
    DROP USER <username>
    

    Parameters

    <username>

    String

    The username for the user you want to delete.

    Example

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