Create User and Grant Role
A 3-step recipe with Snowflake. We can help you get access.
Recipe · 3 steps
Create User and Grant Role
with Snowflake · Identity & Access Management
Create a user, grant a role to them, then list their grants to verify.
- Create the user with login, email, and default role.
- Grant the specified role to the user.
- List all grants to the user to confirm the role was granted.
What you'll need to have ready
- authToken: Bearer token (KEYPAIR_JWT, OAUTH, or programmatic access token).
- tokenType: Value for the X-Snowflake-Authorization-Token-Type header.
- userName: Name of the user to create.
- loginName: Login name for the user.
- email: Email address for the user.
- defaultRole: Default role assigned to the user.
- grant: The grant payload describing the role to grant to the user, including the securable and securable_type.
For your developer
Arazzo workflow snowflake:create-user-and-grant-role, 3 operations: createUser → grant → listGrants. Specs on APIs.io.