Data sharing in a multi-tenant database system
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.
1. 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.
2. The method of claim 1 , wherein the request further causes the target account of the multiple tenant database to:
obtain access rights to an alias object, wherein the alias object references the database object of the first account.
3. The method of claim 2 , wherein the alias object is linked to the database object.
4. The method of claim 2 , wherein the request further causes the target account of the multiple tenant database to: access the database object using the updated access rights of the share object and by way of the alias object without copying the database object.
5. The method of claim 2 , wherein the request further causes the target account of the multiple tenant database to: send a request to access the database object prior to the receiving the access rights.
6. The method of claim 2 , wherein the request further causes the target account of the multiple tenant database to: read the database object without copying the database object.
7. The method of claim 2 , wherein the request further causes the target account of the multiple tenant database to: read the database object without ingesting the database object.
8. The method of claim 2 , wherein the database object comprises database data associated with the first account of the multiple tenant database.
9. 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.
10. The system of claim 9 , wherein the request further causes the target account of the multiple database to: obtain access rights to an alias object, wherein the alias object references the database object of the first account.
11. The system of claim 10 , wherein the alias object is linked to the database object.
12. The system of claim 10 , wherein the request further causes the target account of the multiple database to: access the database object using the updated access rights of the share object and by way of the alias object without copying the database object.
13. The system of claim 9 , wherein the request further causes the target account of the multiple database to: send a request to access the database object prior to the receiving the access rights.
14. The system of claim 9 , wherein the request further causes the target account of the multiple database to: read the database object without copying the database object.
15. The system of claim 9 , wherein the request further causes the target account of the multiple database to: read the database object without ingesting the database object.
16. 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.
17. The non-transitory computer-readable medium of claim 16 , wherein the request further causes the target account of the multiple database to: receive access rights to an alias object, wherein the alias object references the database object of the first account.
18. The non-transitory computer-readable medium of claim 17 , wherein the alias object is linked to the database object.
19. The non-transitory computer-readable medium of claim 17 , wherein the request further causes the target account of the multiple database to: access the database object using the updated access rights of the share object and by way of the alias object without copying the database object.
20. The non-transitory computer-readable medium of claim 16 , wherein the request further causes the target account of the multiple database to: send a request to access the database object prior to the receiving the access rights.
21. The non-transitory computer-readable medium of claim 16 , wherein the request further causes the target account of the multiple database to: read the database object without copying the database object.
22. The non-transitory computer-readable medium of claim 16 , wherein the request further causes the target account of the multiple database to: read the database object without ingesting the database object.