SnowPro Advanced Data Engineer

By Snowflake · Question Mode

QuestionQ68

Design and Manage Snowflake Resources and Performance

A data pipeline creates a new CUSTOMER table in a Snowflake schema with MANAGED ACCESS enabled.

Which roles are able to grant access to the CUSTOMER table?

Choose three
Explanation

Within a Snowflake managed access schema, the table owner cannot grant privileges on the table. Grant authority is centralized with the role that owns the schema and with roles that hold the global MANAGE GRANTS privilege. SECURITYADMIN has that privilege by default, and any role explicitly granted it, including USERADMIN, can grant access within its scope.

Learn more

Community Discussion

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