Is there a way to create objects in snowflake and other users automatically get privileges to modify obj's with schema owner role?

404

nekkanti009

posted on 01 Feb 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




nVector03-Feb-20

After each object is created, the roles has to be assigned to the object to cascade the privileges to all users. To answer your question, there is no way to set it up automatically. But you can always have a recurring process (in unix or any language) that automatically assigns roles on new objects.

Check out this related discussion here

nekkanti00903-Feb-20

oh ok, thanks for the details!