Application roles lack versioning. Consequently, removing an application role or withdrawing a permission from an object situated outside a versioned schema can potentially affect the existing version of an application or the version undergoing an upgrade. It is advisable to drop application roles only when all versions of the application utilizing those roles have been successfully removed.
Copyright 2023 IT Strategists, Inc. All Rights Reserved. Community site to educate and connect Snowflake users, not part of Snowflake Inc.
We share extensive Snowflake Solutions we have synthesized over 6 years of Snowflake Experience and Snowflake Data Superheroes for your Learning Efficiency. Sign up to receive a copy of Frank’s Snowflake Best Practices Blueprint and join 3,000+ others in receiving bi-weekly emails on data, automation and Snowflake optimization from 4x Snowflake Data Superhero.
By Frank Bell and ITS – Snowflake Solutions – Over 3000 subscribers
