ACCOUNTADMIN Role in Snowflake: Definition and Usage
ACCOUNTADMIN role in Snowflake is the highest-level administrative role that has full control over all objects and settings in the account. It can manage users, roles, warehouses, databases, and security policies across the entire Snowflake environment.How It Works
The ACCOUNTADMIN role acts like the master key to your Snowflake account. Imagine it as the owner of a large office building who has access to every room, every security system, and every resource inside. This role can create and manage other roles, users, and all data objects.
Because it has full control, it is responsible for setting up security, managing billing, and configuring account-wide settings. It can grant or revoke permissions to other roles, making it the central point for access control and administration.
Example
This example shows how a user with the ACCOUNTADMIN role can create a new role and grant it privileges.
USE ROLE ACCOUNTADMIN; CREATE ROLE analyst; GRANT USAGE ON WAREHOUSE my_warehouse TO ROLE analyst; GRANT SELECT ON DATABASE my_database TO ROLE analyst;
When to Use
Use the ACCOUNTADMIN role when you need to perform full administrative tasks on your Snowflake account. This includes creating and managing users, roles, warehouses, and databases, as well as configuring security and billing settings.
It is best used by trusted administrators because it has unrestricted access. For daily tasks, assign users more limited roles to reduce risk.
Key Points
- Highest privilege role: Full control over the Snowflake account.
- Manage security: Create and assign roles and permissions.
- Account-wide settings: Control warehouses, databases, and billing.
- Use carefully: Only trusted admins should have this role.
