In my job as a Snowflake Solution Architect, customers have asked me for an example RBAC (role-based access control) model, including scripts and cloning guidelines, that will support DevOps for their PROD, QA, and DEV database environments in a single Snowflake account. Customers have also asked me for an example of how to implement object ownership versus object access in an RBAC model. The following is what I offered in response to these requests. It is only an example, and of course, your database names, roles names, and environment names may differ. …

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store