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.
-
Log into your Snowflake account.
-
Go to Project > Worksheets and either create, or open an existing SQL worksheet.
-
If n the bottom left panel, select Switch role > USERADMIN.
-
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";
-
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.