US 11,853,295 B2
Generation of views with restrictions on use
Marcin Zukowski, San Mateo, CA (US)
Assigned to Snowflake Inc., Bozeman, MT (US)
Filed by Snowflake Inc., Bozeman, MT (US)
Filed on May 24, 2023, as Appl. No. 18/323,200.
Application 18/323,200 is a continuation of application No. 17/150,593, filed on Jan. 15, 2021, granted, now 11,704,306.
Claims priority of provisional application 63/114,326, filed on Nov. 16, 2020.
Prior Publication US 2023/0297563 A1, Sep. 21, 2023
This patent is subject to a terminal disclaimer.
Int. Cl. G06F 16/23 (2019.01); G06F 16/21 (2019.01); G06F 16/2457 (2019.01); G06F 21/62 (2013.01); G06F 16/242 (2019.01)
CPC G06F 16/2393 (2019.01) [G06F 16/21 (2019.01); G06F 16/2445 (2019.01); G06F 16/24573 (2019.01); G06F 21/6227 (2013.01)] 20 Claims
OG exemplary drawing
 
1. A system comprising:
at least one hardware processor; and
at least one memory storing instructions that cause the at least one hardware processor to perform operations comprising:
receiving, from a first computing device of a first user, a restricted view definition defining a view over a database table, the restricted view definition specifying one or more restrictions on use of the view, the one or more restrictions specified by the restricted view definition including at least one restriction applicable to a second user and at least one restriction applicable to a third user;
generating the view over the database table based on the restricted view definition;
receiving, from a second computing device, a query directed at the view;
determining whether the query directed at the view is permitted based on the one or more restrictions on the use of the view specified by the restricted view definition; and
providing, to the second computing device, a response to the query based on a result of determining whether the query directed at the view is permitted.