US 11,868,496 B1
Nested row access policies
Raja Suresh Krishna Balakrishnan, Fremont, CA (US); Jashua Gupta, San Carlos, CA (US); and Jian Xu, San Jose, CA (US)
Assigned to Snowflake Inc., Bozeman, MT (US)
Filed by Snowflake Inc., Bozeman, MT (US)
Filed on Jul. 28, 2023, as Appl. No. 18/227,781.
Claims priority of provisional application 63/507,961, filed on Jun. 13, 2023.
Int. Cl. G06F 21/62 (2013.01)
CPC G06F 21/6218 (2013.01) 19 Claims
OG exemplary drawing
 
1. A method of referencing a mapping table in a data table, the method comprising:
defining, by a processing device, a first access policy for the mapping table to control access by specific users or under specific conditions;
defining, by the processing device, a second access policy attached to the data table referencing the mapping table; and
in response to a query, executing, by the processing device, 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, wherein executing the second access policy invokes executing the first access policy of the mapping table.