Snowflake inc. (20250005192). IMPLEMENTING INHERITED GRANTS USING SECURE SCHEMAS
IMPLEMENTING INHERITED GRANTS USING SECURE SCHEMAS
Organization Name
Inventor(s)
Sepideh Khoshnood of Issaquah WA US
IMPLEMENTING INHERITED GRANTS USING SECURE SCHEMAS
This abstract first appeared for US patent application 20250005192 titled 'IMPLEMENTING INHERITED GRANTS USING SECURE SCHEMAS
Original Abstract Submitted
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.