AUTHORIZATION ON USER DEFINED ENTITY TYPES

    公开(公告)号:US20250111070A1

    公开(公告)日:2025-04-03

    申请号:US18375252

    申请日:2023-09-29

    Applicant: Snowflake Inc.

    Abstract: Disclosed are techniques for providing scoped grants that provide object-specific authorization for privileges on user-defined objects. A scoped grant is a grant of a generalized, non-specific privilege that also limits the contexts in which that grant is applicable (i.e., scopes the grant) during authorization, where the “context” is defined by the user-defined object upon which the privilege is being performed. A user statement requesting a grant of a privilege on a user-defined object may be received. A scoped privilege that provides a grant of a base privilege identified from the user statement and limits application of the grant of the base privilege to the user-defined object is created. Scoping object information associated with the user-defined object is provided to an authorization engine, wherein the scoping information includes a set of properties identifying the user-defined object. A scoped grant is created based on the scoped privilege using the scoping object information.

    Grant inheritance in RBAC
    2.
    发明授权

    公开(公告)号:US12105828B2

    公开(公告)日:2024-10-01

    申请号:US18227818

    申请日:2023-07-28

    Applicant: Snowflake Inc.

    Abstract: Embodiments of the present disclosure provide systems and methods for using inherited grants to grant privileges to objects in a container. An inherited grant may be generated that specifies a permission on a first type of object in a container and a grant of the permission to a role. The inherited grant may be attached to the container, wherein the container includes a set of objects of the first type. In response to a first object of the set of objects being referenced via the role, a virtual implied grant may be created based on the inherited grant. Authorization of utilization of the permission on the first object is performed using the virtual implied grant, wherein the virtual implied grant is transient and exists in-memory only for the purpose of authorizing the utilization of the permission on the first object.

    IMPLEMENTING INHERITED GRANTS USING SECURE SCHEMAS

    公开(公告)号:US20240169077A1

    公开(公告)日:2024-05-23

    申请号:US18228546

    申请日:2023-07-31

    Applicant: Snowflake Inc.

    CPC classification number: G06F21/604 G06F21/6218

    Abstract: Embodiments of the present disclosure provide systems and methods for using secure schemas to address inconsistencies between standard RBAC rules and the use of inherited grants. A secure schema may be defined that transfers ownership of an object created in the secure schema to a role that owns the secure schema. An inherited grant may be attached to the secure schema, where the inherited grant specifies a permission on a first type of object in the secure schema and a grant of the permission to the role that owns the secure schema. When objects are created in the secure schema, ownership of each of the set of objects is transferred to the role that owns the secure schema to authorize the role that owns the secure schema to manage grants to the set of objects on the secure schema.

    GRANT INHERITANCE IN RBAC
    8.
    发明公开

    公开(公告)号:US20240169086A1

    公开(公告)日:2024-05-23

    申请号:US18227818

    申请日:2023-07-28

    Applicant: Snowflake Inc.

    CPC classification number: G06F21/6227

    Abstract: Embodiments of the present disclosure provide systems and methods for using inherited grants to grant privileges to objects in a container. An inherited grant may be generated that specifies a permission on a first type of object in a container and a grant of the permission to a role. The inherited grant may be attached to the container, wherein the container includes a set of objects of the first type. In response to a first object of the set of objects being referenced via the role, a virtual implied grant may be created based on the inherited grant. Authorization of utilization of the permission on the first object is performed using the virtual implied grant, wherein the virtual implied grant is transient and exists in-memory only for the purpose of authorizing the utilization of the permission on the first object.

Patent Agency Ranking