Answer: ACCOUNTADMIN

The ACCOUNTADMIN role has the default ability to create a share from a shared database in Snowflake. This is confirmed by the community discussion where multiple users with upvotes (including one with 3 upvotes) explicitly state that ACCOUNTADMIN is the correct answer, noting that this role is required by default to create and manage shares. The other roles - SECURITYADMIN, SYSADMIN, and ORGADMIN - do not have this capability by default. SECURITYADMIN manages security policies and user roles, SYSADMIN manages system-level resources, and ORGADMIN manages organization-level settings, but none of these roles inherently include share creation privileges without explicit grants.

Author: LeetQuiz Editorial Team