Add a user to Direct Data Access

You require the USERADMIN role to add a user and assign a role for Direct Data Access. It is a predefined role that allows you to manage users and roles and is the role assigned to the first user when the Snowflake account is set up.

1. Log into your Snowflake account.

2. Go to Project > Worksheets and either create, or open an existing SQL worksheet.

3. If n the bottom left panel, select Switch role > USERADMIN.

4. Paste the following SQL commands into the worksheet, change the details highlighted in bold text, and then select Run All:

   CREATE USER IF NOT EXISTS "USERNAME" PASSWORD = "PASSWORD" DEFAULT_ROLE = share_user MUST_CHANGE_PASSWORD = true EMAIL = "EMAIL";

   GRANT ROLE share_user to USER "USERNAME";

5. Provide the user with their temporary password and the URL they need to access their account using one of the IP addresses on our Allow list.