Setting up Snowflake Account Using System-Defined Roles
With a Snowflake account readily available to use and a limited understanding of its system-defined roles, it usually becomes a challenge for a team lead or an admin to set up the environments with proper access controls to its developers or users.
To start with the account setup, first, you would be needing a user which has ACCOUNTADMIN role access for the Snowflake account. This can be provided by a user who has ORGADMIN Snowflake account access.
This is understood by the example below:
An organization has one Snowflake organization-wide account and is managed by ORGADMIN.
ORGADMIN can create multiple accounts under the same organization in Snowflake, which can be separately managed by different teams within the organization.