Snowflake object owners lose their ability to grant privileges on their own objects when those objects reside in a managed access schema. In standard (non‑managed) schemas, object owners (roles holding the OWNERSHIP privilege on the object) can grant or revoke privileges. However, in a managed access schema—created via CREATE SCHEMA … WITH MANAGED ACCESS—only the schema owner (the role with OWNERSHIP on the schema) or any role with the global MANAGE GRANTS privilege can grant privileges on objects within that schema; individual object owners are no longer authorized to make grant decisions.
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Billhardy
1Â week, 5Â days ago