Granted Patent B2

US 12,242,636 · App. 17/844,601 · Granted Mar 4, 2025

Inventors: Allison Waingold Lee (San Mateo, CA); Peter Povinec (Redwood City, CA); Martin Hentschel (Seattle, WA); Robert Muglia (Mercer Island, WA)

Assignee: Snowflake Inc.

G06F21/6227G06F16/2282G06F16/245G06F21/6218

Abstract

Claims (63)

1. A multi-tenant database system comprising:

a memory; and

one or more processors operatively coupled to the memory, the one or more processors to:

receive a grant to access a share object comprising a plurality of functions associated with a secure user-defined function (UDF) to underlying data;

access the share object using the grant;

send a request to a share component to cause the share component to:

determine that a first function of the plurality of functions produces errors;

annotate the first function of the plurality of functions with a safety property indicating that the first function produces errors;

implement a second function of the plurality of functions by pushing the second function through a secure view boundary;

prevent, based on the safety property, an implementation of the second function by ensuring that the second function is not pushed through the secure view boundary;

hide the secure UDF from a second account having access to a view associated with a first account by modifying an output of commands to prevent the second account from receiving the secure UDF; and

receive, by the first account from the secure UDF, the functionality to the underlying data, wherein the functionality prevents the first account from using the functionality to access unauthorized data by preventing the first account from receiving metadata associated with the underlying data.

2. The multi-tenant database system of claim 1 , wherein the share object further comprises one or more of:

a data field of an underlying table of the share object;

a structural element of an underlying table of the share object; or

a quantity of data in an underlying table of the share object.

3. The multi-tenant database system of claim 1 , wherein the grant to access the share object is without access rights to a view of a procedural logic associated with the secure UDF, and wherein the procedural logic associated with the secure UDF comprises one or more of:

a table access according to the secure UDF; or

a quantity of data processed according to the secure UDF.

4. The multi-tenant database system of claim 1 , wherein the secure UDF is a scalar UDF comprising parameters such that the scalar UDF returns at least one of a single row or a single column, and further comprising:

receiving one or more of a simple SQL expression or a subquery.

5. The multi-tenant database system of claim 1 , wherein the secure UDF is a table-valued UDF comprising a correlated table.

6. The multi-tenant database system of claim 1 , wherein the grant to access the share object is without access rights to a view of a procedural logic associated with the secure UDF.

7. A method, comprising:

receiving a grant to access a share object comprising a plurality of functions associated with a secure user-defined function (UDF) to underlying data;

accessing the share object using the grant;

sending a request to a share component to cause the share component to:

determine that a first function of the plurality of functions produces errors;

annotate the first function of the plurality of functions with a safety property indicating that the first function produces errors;

implement a second function of the plurality of functions by pushing the second function through a secure view boundary;

prevent, based on the safety property, an implementation of the second function by ensuring that the second function is not pushed through the secure view boundary;

hide the secure UDF from a second account having access to a view associated with a first account by modifying an output of commands to prevent the second account from receiving the secure UDF; and

receiving, from the secure UDF, the functionality to the underlying data, wherein the functionality prevents the first account from using the functionality to access unauthorized data by preventing the first account from receiving metadata associated with the underlying data.

8. The method of claim 7 , wherein the share object further comprises one or more of:

a data field of an underlying table of the share object;

a structural element of an underlying table of the share object; or

a quantity of data in an underlying table of the share object.

9. The method of claim 7 , wherein the grant to access the share object is without access rights to a view of a procedural logic associated with the secure UDF, and wherein the procedural logic associated with the secure UDF comprises one or more of:

a table accessed according to the secure UDF; or

a quantity of data processed according to the secure UDF.

10. The method of claim 7 , wherein the secure UDF is a scalar UDF comprising parameters such that the scalar UDF returns at least one of a single row or a single column, and further comprising:

receiving one or more of a simple SQL expression or a subquery.

11. The method of claim 9 , wherein the share object is accessible in a query profile as a single node.

12. The method of claim 11 , wherein the procedural logic is not exposed in the query profile.

13. The method of claim 7 , wherein the grant to access the share object is without access rights to a view of a procedural logic associated with the secure UDF.

14. A non-transitory computer readable storage media storing instructions that, when executed by one or more processors of a multi-tenant database, cause the one or more processors to:

receive, by the one or more processors, a grant to access a share object comprising functionality associated with a secure user-defined function (UDF) to underlying data;

access, by the one or more processors, the share object using the grant;

send a request to a share component to cause the share component to:

determine that a first function of the plurality of functions produces errors;

annotate the first function of the plurality of functions with a safety property indicating that the first function produces errors;

implement a second function of the plurality of functions by pushing the second function through a secure view boundary;

prevent, based on the safety property, an implementation of the second function by ensuring that the second function is not pushed through the secure view boundary;

hide the secure UDF from a second account having access to a view associated with a first account by modifying an output of commands to prevent the second account from receiving the secure UDF; and

receive, by the first account from the secure UDF, the functionality to the underlying data, wherein the functionality prevents the first account from using the functionality to access unauthorized data by preventing the first account from receiving metadata associated with the underlying data.

15. The non-transitory computer readable storage media of claim 14 , wherein the share object further comprises one or more of:

a data field of an underlying table of the share object;

a structural element of an underlying table of the share object; or

a quantity of data in an underlying table of the share object.

16. The non-transitory computer readable storage media of claim 14 , wherein the grant to access the share object is without access rights to a view of a procedural logic associated with the secure UDF, and wherein the procedural logic associated with the secure UDF comprises one or more of:

a table access according to the secure UDF; or

a quantity of data processed according to the secure UDF.

17. The non-transitory computer readable storage media of claim 14 , wherein the grant to access the share object is without access rights to a view of a procedural logic associated with the secure UDF.

Continuity (5)

References Cited (78)