公开(公告)号：US20240419828A1

公开(公告)日：2024-12-19

申请号：US18394531

申请日：2023-12-22

Applicant: Snowflake Inc.

Inventor： Raja Suresh Krishna Balakrishnan ,  Jashua Gupta ,  Jian Xu

IPC: G06F21/62

Abstract: Methods of referencing row access policy (RAP) protected mapping tables in a RAP for a data table are disclosed herein. An example method of referencing a mapping table in a data table using nested RAP includes defining, by a processing device, a first access policy for the mapping table to control access by specific users or under specific conditions. The processing device further defines a second access policy attached to the data table referencing the mapping table. The processing device in response to a query, executes the second access policy of the data table to provide a response or operation of data associated with the data table and the mapping table. Executing the second access policy invokes executing the first access policy of the mapping table. The executing of both the second access policy of the data table and the first access policy of the mapping table are recorded.

公开(公告)号：US12259991B2

公开(公告)日：2025-03-25

申请号：US18394531

申请日：2023-12-22

Applicant: Snowflake Inc.

Inventor： Raja Suresh Krishna Balakrishnan ,  Jashua Gupta ,  Jian Xu

IPC: G06F21/62

Abstract: Methods of referencing row access policy (RAP) protected mapping tables in a RAP for a data table are disclosed herein. An example method of referencing a mapping table in a data table using nested RAP includes defining, by a processing device, a first access policy for the mapping table to control access by specific users or under specific conditions. The processing device further defines a second access policy attached to the data table referencing the mapping table. The processing device in response to a query, executes the second access policy of the data table to provide a response or operation of data associated with the data table and the mapping table. Executing the second access policy invokes executing the first access policy of the mapping table. The executing of both the second access policy of the data table and the first access policy of the mapping table are recorded.

公开(公告)号：US11868496B1

公开(公告)日：2024-01-09

申请号：US18227781

申请日：2023-07-28

Applicant: Snowflake Inc.

Inventor： Raja Suresh Krishna Balakrishnan ,  Jashua Gupta ,  Jian Xu

IPC: G06F21/62

CPC classification number: G06F21/6218

Abstract: This disclosure provides methods and techniques of referencing row access policy (RAP) protected mapping tables in a RAP for a data table are disclosed herein. An example method of referencing a mapping table in a data table using nested RAP includes defining, by a processing device, a first access policy for the mapping table to control access by specific users or under specific conditions. The processing device further defines a second access policy attached to the data table referencing the mapping table. The processing device in response to a query, executes the second access policy of the data table to provide a response or operation of data associated with the data table and the mapping table. Executing the second access policy invokes executing the first access policy of the mapping table.