Invention Grant
- Patent Title: Nested row access policies
-
Application No.: US18394531Application Date: 2023-12-22
-
Publication No.: US12259991B2Publication Date: 2025-03-25
- Inventor: Raja Suresh Krishna Balakrishnan , Jashua Gupta , Jian Xu
- Applicant: Snowflake Inc.
- Applicant Address: US MT Bozeman
- Assignee: Snowflake Inc.
- Current Assignee: Snowflake Inc.
- Current Assignee Address: US MT Bozeman
- Agency: Womble Bond Dickinson (US) LLP
- Main IPC: G06F21/62
- 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.
Public/Granted literature
- US20240419828A1 NESTED ROW ACCESS POLICIES Public/Granted day:2024-12-19
Information query