In-database application package and application

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.

A computer-storage medium comprising instructions that, when executed by one or more processors of a machine, configure the machine 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.