More about access control and granular level
✅ Role-Level Access Control (RBAC)
-
What it is: RBAC is a security framework where permissions are granted to roles, not directly to users. Users are assigned to roles → roles have privileges on objects → users inherit those privileges.
-
Hierarchy: Snowflake allows role hierarchy, so a parent role inherits privileges from its child roles.
-
Why it matters:
- Centralized and scalable security.
- Easier management (you manage roles, not users).
- Supports least privilege principle.