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

Snowflake UI showing USER_VIEW selected under ACCOUNT_MANAGEMENT > PUBLIC > Views, with the Data Preview tab active and SUPPORT_TESTING_WH warehouse selected from the dropdown, displaying user records with CREATED_ON, DELETED_ON, and LOGIN_NAME columns. — This will give you a comprehensive look at your users and their current state

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>

Setting Up Multi Factor Authentication

⌘I

Hosted Database

Overview

How Tos

Common Queries

Elation Billing

Frequently Asked Questions

Changelog

Viewing a list of Users

Creating a new User

Creating a new Role

Creating a new User and assigning it to a new Role

Granting a Role to an Existing User

Disable a User’s access

​Viewing a list of Users

​Creating a new User

​Creating a new Role

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

​Granting a Role to an Existing User

​Disable a User’s access

Viewing a list of Users

Creating a new User

Creating a new Role

Creating a new User and assigning it to a new Role

Granting a Role to an Existing User

Disable a User’s access