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

# Managing your users

## 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

<Frame caption="This will give you a comprehensive look at your users and their current state">
  <img src="https://mintcdn.com/elationhealth/c_0GuvXN24rkf1qg/images/reference/snowflake-user-view-data-preview.png?fit=max&auto=format&n=c_0GuvXN24rkf1qg&q=85&s=895f8550f81c75d0f455381f83888bdb" width="3504" height="980" data-path="images/reference/snowflake-user-view-data-preview.png" />
</Frame>

**Worksheet**

Step 1: Go into a worksheet

Step 2: Run the below command

<CodeGroup>
  ```sql sql theme={null}
  SHOW USERS;
  ```
</CodeGroup>

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

<CodeGroup>
  ```sql sql theme={null}
  CREATE USER <user_name> PASSWORD = '<password_here>' DEFAULT_ROLE = <NameOfROLE> MUST_CHANGE_PASSWORD = TRUE;
  ```
</CodeGroup>

## Creating a new Role

You can create a new role by running the below statement in a new worksheet

<CodeGroup>
  ```sql sql theme={null}
  CREATE ROLE <ROLE_NAME>;
  ```
</CodeGroup>

## 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

<CodeGroup>
  ```sql sql theme={null}
  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>;
  ```
</CodeGroup>

<Info>
  * 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
</Info>

## Granting a Role to an Existing User

You can grant an existing role to an existing user by

<CodeGroup>
  ```sql sql theme={null}
  GRANT ROLE <YOURROLE> TO USER <user_name>;
  ```
</CodeGroup>

## Disable a User's access

Please reach out to [Elation Support Portal](/articles/support-portal-introduction) 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](/articles/support-portal-introduction) with the subject line HDB - \<your\_question>*