Data sharing in a multi-tenant database system
AssigneeSnowflake Inc.
InventorsBenoit Dageville, Thierry Cruanes, Martin Hentschel, Peter Povinec
Life of this patent
Estimating the term…
Abstract
A method for sharing data in a multi-tenant database includes receiving, by a target account of a multiple tenant database, access rights of a share object in a first account of the multiple tenant database, wherein the share object having access rights to a database object of the first account and wherein access to the database object of the first account by the target account is based on the access rights of the share object. The method also includes receiving, by one or more processors of the target account, access rights to an alias object, wherein the alias object references the database object of the first account.
Claims22
A method comprising:
- sending, by a processing device to a target account of a multiple tenant database, a request for a database object associated with a first account of the multiple tenant database, the request causes the target account of the multiple database to:
- obtain access rights of a share object in the first account of the multiple tenant database, wherein the share object having access rights to the database object of the first account, wherein the access rights of the share object are updated after the target account obtains the access rights of the share object;
- and access the database object of the first account based on the updated access rights of the share object and without a transmission of the database object;
- and
- receiving, by the processing device from the multiple tenant database, the database object associated with the first account of the multiple tenant database.
A system comprising:
- a memory;
- and
- one or more processors executing a target account and operatively coupled to the memory, the one or more processors to:
- send, to a target account of a multiple tenant database, a request for a database object associated with a first account of the multiple tenant database, the request causes the target account of the multiple database to:
- obtain access rights of a share object in the first account of a multiple tenant database, wherein the share object having access rights to the database object of the first account, wherein the access rights of the share object are updated after the target account obtains the access rights of the share object;
- and access the database object of the first account based on the updated access rights of the share object and without a transmission of the database object;
- and
- receive, from the multiple tenant database, the database object associated with the first account of the multiple tenant database.
A non-transitory computer-readable medium having instructions stored thereon that, when executed by one or more processors, causes the one or more processors to:
- send, to a target account of a multiple tenant database, a request for a database object associated with a first account of the multiple tenant database, the request causes the target account of the multiple database to:
- obtain access rights of a share object in the first account of a multiple tenant database, wherein the share object having access rights to the database object of the first account, wherein the access rights of the share object are updated after the target account obtains the access rights of the share object;
- and access the database object of the first account based on the updated access rights of the share object and without a transmission of the database object;
- and
- receive, from the multiple tenant database, the database object associated with the first account of the multiple tenant database.
Dependencies are inferred from the claim text.