Skip to main content

Documentation Index

Fetch the complete documentation index at: https://help.elationhealth.com/llms.txt

Use this file to discover all available pages before exploring further.

​
Viewing a list of Users

You can view a list of users and their status by either: Accessing USER_VIEW Step 1: On the left hand navigation bar clicking on Data > Databases Step 2: Clicking on ACCOUNT_MANAGEMENT > Public Step 3: Then Click on USER_VIEW and picking your warehouse under Data Preview
Worksheet Step 1: Go into a worksheet Step 2: Run the below command 
SHOW USERS;
This will not give you as much information as USER_VIEW but will give you a quick summary of your users.

​
Creating a new User

You can create a new user by running the below statement in a new worksheet 
CREATE USER <user_name> PASSWORD = '<password_here>' DEFAULT_ROLE = <NameOfROLE> MUST_CHANGE_PASSWORD = TRUE;

​
Creating a new Role

You can create a new role by running the below statement in a new worksheet 
CREATE ROLE <ROLE_NAME>;

​
Creating a new User and assigning it to a new Role

You can create a new user and assign it to a new role by running the below statement in a new worksheet 
CREATE ROLE <YOURNEWROLE>;
CREATE USER <user_name> PASSWORD = '<password_here>' DEFAULT_ROLE = <YOURNEWROLE> MUST_CHANGE_PASSWORD = TRUE;
GRANT ROLE <YOURNEWROLE> TO USER <user_name>;
GRANT SELECT to all tables in schema your_table_name.your_schema_name to role <YOURNEWROLE>;
  • You only have to create a ROLE once, then you can assign it to other users
  • New Roles created will only have permissions to read and query the data
  • You can assign the existing USERADMIN roles to other users you create but you will be granting them permission to:
    • Create users
    • Create new roles
    • Create tables

​
Granting a Role to an Existing User

You can grant an existing role to an existing user by 
GRANT ROLE <YOURROLE> TO USER <user_name>;

​
Disable a User’s access

Please reach out to Elation Support Portal to disable a user’s access with the subject line HDB - <Disable user’s access> along with the username and email.
If you have any questions about this topic please reach out to Elation Support Portal with the subject line HDB - <your_question>
Using worksheets to write queries Setting Up Multi Factor Authentication