US 11,983,292 B2
Native applications using database roles
Damien Carru, New York, NY (US); Jeremy Yujui Chen, Waterloo (CA); Pui Kei Johnston Chu, Unionville (CA); Thierry Cruanes, San Mateo, CA (US); Istvan Cseri, Seattle, WA (US); Benoit Dageville, San Carlos, CA (US); Unmesh Jagtap, San Mateo, CA (US); and Subramanian Muralidhar, Mercer Island, WA (US)
Assigned to Snowflake Inc., Bozeman, MT (US)
Filed by Snowflake Inc., Bozeman, MT (US)
Filed on Feb. 13, 2023, as Appl. No. 18/167,950.
Application 18/167,950 is a continuation of application No. 17/885,335, filed on Aug. 10, 2022, granted, now 11,593,509.
Application 17/885,335 is a continuation of application No. 17/535,529, filed on Nov. 24, 2021, granted, now 11,436,362, issued on Sep. 6, 2022.
Claims priority of provisional application 63/273,814, filed on Oct. 29, 2021.
Prior Publication US 2023/0185952 A1, Jun. 15, 2023
This patent is subject to a terminal disclaimer.
Int. Cl. G06F 21/62 (2013.01); G06F 9/445 (2018.01); G06Q 30/06 (2023.01)
CPC G06F 21/6227 (2013.01) [G06F 9/44505 (2013.01); G06Q 30/06 (2013.01); G06F 2221/2141 (2013.01)] 20 Claims
OG exemplary drawing
 
1. A method comprising:
defining an installation script to install an application in a data exchange implemented in a cloud computing environment, wherein the data exchange comprises a provider account and a consumer account, wherein the provider account is to share a data asset with the consumer account;
creating a share object of a database in the provider account and attaching the installation script to the share object, wherein the share object includes information used to share the data asset in the database with the consumer account; and
replicating, by a processing device, the database from the provider account to the consumer account based on the share object, wherein the installation script executes within the consumer account to install the application in the consumer account of the data exchange responsive to the replicating, and wherein execution of the application in the consumer account is managed by a set of database roles that determine access privileges granted to the application for accessing the data asset in the database inside the consumer account, the application to perform a data processing service relative to the data asset in the database.