1 Answer

0 votes
by

A Snowflake role is an entity that can grant and revoke privileges on securable objects such as databases, tables, and schemas. Users are assigned roles that enable them to perform actions required for the organization's business functions.

Snowflake has two types of roles.

System-defined roles:

These are predefined roles provided by Snowflake for common administrative and operational tasks. These include ACCOUNTADMIN, SECURITYADMIN, USERADMIN, SYSADMIN, PUBLIC, etc. System-defined roles cannot be modified or deleted.

Custom role:

These are custom roles that you can create and customize for your specific needs and use cases. Custom roles can inherit permissions from other roles, including system-defined roles. Custom roles can be created, modified, and deleted by users with appropriate privileges. 

...