Posts

Showing posts from December, 2025

Access control framework

OWNERSHIP privilege When a user logs in to Snowflake, that users default primary role gets activated for the current session. In addition the user may also have secondary roles that may also get activated for that session if they have been configured that way at the login stage or the user configuration stage. In Snowflake users do not own objects, rather Ownership is a privilege that is granted to the primary role to which the user belongs to and is active during the creation of that object. Which means all users belonging to that same role also gets the ownership. Note A role owner (the role that has the OWNERSHIP privilege on the role) does  not  inherit the privileges of the owned role. Privilege inheritance is only possible within a role hierarchy. How Role Activation Works at Login When a user connects to the system (like Snowflake), the active role for their session is determined by the following hierarchy: Priority Scenario Active Role Set 1st Role explicitly specified...