Data sharing using alias objects
A method of sharing data in a multi-tenant database includes inspecting, by a processing device of a multiple tenant database, a sharer account to determine a presence of a grant to a second role object, in a target account, of access rights to a first role object included in the sharer account. The method includes granting the second role object, in the target account, access rights to an alias object. The first role object having one or more grants to the one or more resources of the sharer account. The target account accesses the one or more resources using the one or more grants of the first role object and using the alias object without at least one of copying the one or more resources or transmitting the one or more resources.
1. A method comprising:
inspecting, by a processing device of a multiple tenant database, a sharer account to determine a presence of a grant to a second role object, in a target account, of access rights to a first role object included in a share object in the sharer account;
inspecting, by the processing device, the sharer account to determine an existence of a link between an alias object in the target account and a database linked to the first role object; and
granting the second role object, in the target account, access rights to the alias object, wherein the first role object having one or more grants to one or more resources of the sharer account, and wherein the target account accesses the one or more resources using the one or more grants of the share object and using the alias object without at least one of copying the one or more resources or transmitting the one or more resources.
2. The method of claim 1 , wherein each grant of the one or more grants comprises at least one of a usage grant, a modification grant, or a select grant.
3. The method of claim 1 , wherein when the alias object is used, the alias object is internally replaced by an object associated with the one or more resources of the sharer account.
4. The method of claim 1 , wherein the sharer account and the target account are accounts within the multiple tenant database.
5. The method of claim 1 , wherein the alias object references a dataset associated with the one or more resources of the sharer account and the sharer account shares the one or more grants with one or more other target accounts such that the one or more other target accounts can read the dataset without copying or transmitting the dataset using one or more virtual warehouses corresponding to the one or more other target accounts.
6. The method of claim 1 , wherein the alias object references database data associated with the one or more resources of the sharer account.
7. The method of claim 1 , further comprising:
receiving a request for access to the one or more resources; and
processing the request using a virtual warehouse, wherein the virtual warehouse comprises a set of one or more compute nodes configured to access data in a storage layer corresponding to the sharer account to generate a response to the request.
8. The method of claim 1 , wherein the alias object serves as a proxy for an object associated with the one or more resources of the sharer account.
9. The method of claim 1 , further comprising:
creating a link between the alias object and an object associated with the one or more resources of the sharer account.
10. The method of claim 1 , wherein the alias object references an object associated with the one or more resources of the sharer account, the one or more resources of the sharer account are organized in an object hierarchy, and the object is at the top of the object hierarchy.
11. A system comprising:
a memory; and
one or more processors operatively coupled to the memory, the one or more processors to:
inspect a sharer account to determine a presence of a grant to a second role object, in a target account, of access rights to a first role object included in a share object in the sharer account;
inspect the sharer account to determine an existence of a link between an alias object in the target account and a database linked to the first role object; and
grant the second role object, in the target account, access rights to the alias object, wherein the first role object having one or more grants to one or more resources of the sharer account, and wherein the target account accesses the one or more resources using the one or more grants of the share object and using the alias object without at least one of copying the one or more resources or transmitting the one or more resources.
12. The system of claim 11 , wherein each grant of the one or more grants comprises at least one of a usage grant, a modification grant, or a select grant.
13. The system of claim 11 , wherein when the alias object is used, the alias object is internally replaced by an object associated with the one or more resources of the sharer account.
14. The system of claim 11 , wherein the sharer account and the target account are accounts within the multiple tenant database.
15. The system of claim 11 , wherein the alias object references a dataset associated with the one or more resources of the sharer account and the sharer account shares the one or more grants with one or more other target accounts such that the one or more other target accounts can read the dataset without copying or transmitting the dataset using one or more virtual warehouses corresponding to the one or more other target accounts.
16. The system of claim 11 , wherein the alias object references database data associated with the one or more resources of the sharer account.
17. The system of claim 11 , wherein the one or more processor further to:
receive a request for access to one or more resources; and
process the request using a virtual warehouse, wherein the virtual warehouse comprises a set of one or more compute nodes configured to access data in a storage layer corresponding to the sharer account to generate a response to the request.
18. The system of claim 11 , wherein the alias object serves as a proxy for an object associated with the one or more resources of the sharer account.
19. The system of claim 11 , wherein the one or more processors further to:
create a link between the alias object and an object associated with the one or more resources of the sharer account.
20. The system of claim 11 , wherein the alias object references an object associated with the one or more resources of the sharer account, the one or more resources of the sharer account are organized in an object hierarchy, and the object is at the top of the object hierarchy.
21. 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:
inspect a sharer account to determine a presence of a grant to a second role object, in a target account, of access rights to a first role object included in a share object in the sharer account;
inspect the sharer account to determine an existence of a link between an alias object in the target account and a database linked to the first role object; and
grant the second role object, in the target account, access rights to the alias object, wherein the first role object having one or more grants to one or more resources of the sharer account, and wherein the target account accesses the one or more resources using the one or more grants of the share object and using the alias object without at least one of copying the one or more resources or transmitting the one or more resources.
22. The non-transitory computer-readable medium of claim 21 , wherein each grant of the one or more grants comprises at least one of a usage grant, a modification grant, or a select grant.
23. The non-transitory computer-readable medium of claim 21 , wherein when the alias object is used, the alias object is internally replaced by an object associated with the one or more resources of the sharer account.
24. The non-transitory computer-readable medium of claim 21 , wherein the sharer account and the target account are accounts within the multiple tenant database.
25. The non-transitory computer-readable medium of claim 21 , wherein the alias object references a dataset associated with the one or more resources of the sharer account and the sharer account shares the one or more grants with one or more other target accounts such that the one or more other target accounts can read the dataset without copying or transmitting the dataset using one or more virtual warehouses corresponding to the one or more other target accounts.
26. The non-transitory computer-readable medium of claim 21 , wherein the alias object references database data associated with the one or more resources of the sharer account.
27. The non-transitory computer-readable medium of claim 21 , wherein the one or more processors further to:
receive a request for access to the one or more resources; and
process the request using a virtual warehouse, wherein the virtual warehouse comprises a set of one or more compute nodes configured to access data in a storage layer corresponding to the sharer account to generate a response to the request.
28. The non-transitory computer-readable medium of claim 21 , wherein the alias object serves as a proxy for an object associated with the one or more resources of the sharer account.
29. The non-transitory computer-readable medium of claim 21 , wherein the one or more processors further to:
create a link between the alias object and an object associated with the one or more resources of the sharer account.
30. The non-transitory computer-readable medium of claim 21 , wherein the alias object references an object associated with the one or more resources of the sharer account, the one or more resources of the sharer account are organized in an object hierarchy, and the object is at the top of the object hierarchy.