Granting Access to a Role on newly created schema's automatically without manual intervention
I have a role created in snowflake and would like to grant all privilege on existing schema's in a database. Actual requirement for me is, when a new schema is added in that particular database at a later time i would like to grant same access without manually running "grant all on schema.." command in a database. Any suggestions on how this can be achieved? I know we can grant future grants on schema objects, but i am looking for future grants on the new schema itself.Please advise.
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