Patent ID: 11886872
Assignee: SNOWFLAKE INC.
Field: Computer technology (Electrical engineering)
Classification: CPC G | IPC G

Claim 10:
11. A data platform comprising:
at least one processor; and
at least one memory storing instructions that cause the at least one processor to perform operations comprising:
creating an application instance of an application package having a versioned schema;
creating one or more system roles for the application instance based on the versioned schema;
creating one or more user roles for the application instance based on the versioned schema;
creating one or more objects of the application instance based on the versioned schema;
granting one or more usages to the one or more user roles based on the versioned schema, the one or more usages comprising use privileges to access objects of the application package; and
determining, by a first procedure, a version context of a second procedure based on a versioned schema, wherein the version context of the second procedure is determined by rules comprising;
in response to determining the second procedure is associated with a call context, use a version of a call context of the first procedure and the second procedure;
in response to determining there is a global version set on a parent database of the first procedure and the second procedure, use the global version; and
in response to determining the second procedure not associated with the call context and no global version set on the parent database, use an active version associated with the versioned schema.