Snowflake DBA

Access Control & Roles

Question

RBAC vs. UBAC: how do Snowflake privilege assignments differ?

Answer

RBAC grants object privileges to roles, then grants roles to users. UBAC grants privileges directly to users. Use RBAC for durable job-function access; use direct user grants sparingly, noting they participate when secondary roles are set to ALL.

This is 3 of 21 free samples for Snowflake DBA.

More Snowflake DBA topic samples