Manage Grants privilege to a role at Database Level

404

posted on 30 Mar 20

Enjoy great content like this and a lot more !

Signup for a free account to write a post / comment / upvote posts. Its simple and takes less than 5 seconds

Post Comment

nVector30-Mar-20

From the snowflake documentation,

Manage Grants is only available at ACCOUNT level, not at database level
However, The schema owner (i.e. the role with the OWNERSHIP privilege on the schema) can grant privileges on objects in the schema, including future grants.

So, that is something you could use for your scenario

Thanks for the response and above details. This is what i have read on snowflake documentation but wanted to make sure am not missing anything.