18394531. NESTED ROW ACCESS POLICIES (Snowflake Inc.)
Contents
NESTED ROW ACCESS POLICIES
Organization Name
Inventor(s)
Raja Suresh Krishna Balakrishnan of Fremont CA (US)
Jashua Gupta of San Carlos CA (US)
NESTED ROW ACCESS POLICIES
This abstract first appeared for US patent application 18394531 titled 'NESTED ROW ACCESS POLICIES
Original Abstract Submitted
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.
