I’ve written about Role-based Access Control (RBAC) in Snowflake previously. One of the topics I discussed was how to resolve cross-database access.
This has now been simplified since Snowflake introduced secondary roles. I wrote in more detail about how secondary roles can be used together with RBAC in this blog post on Medium.