QuestionQ59

Account Management & Data Governance

In a managed access schema, which role or privilege may grant permissions on schema objects to other roles?

Choose two
Explanation

In a Snowflake managed access schema, grant authority is centralized: only the schema owner (the role with OWNERSHIP on the schema) or a role that has the global MANAGE GRANTS privilege can grant privileges on objects in that schema, including future grants. Object ownership and roles such as SYSADMIN alone do not confer this authority.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!