Which system role is recommended for a custom role hierarchy to be ultimately assigned to?
Which system role is recommended for a custom role hierarchy to be ultimately assigned to?
The ACCOUNTADMIN role is the most powerful system role in Snowflake. It has ownership of the Snowflake account and is responsible for all aspects of account management. This role is generally used to manage and control the system, making it the recommended role for assigning a custom role hierarchy. The SYSADMIN role, while important for managing objects and users, does not have the overarching control required for a custom role hierarchy ownership.
Snowflake recommends creating a hierarchy of custom roles, with the top-most custom role assigned to the system role SYSADMIN