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.