Data sharing in a multi-tenant database system

A non-transitory computer readable storage media storing instructions that, when executed by one or more processors, cause the one or more processors to:

• determine that a first account of a multiple tenant database grants to a second account of the multiple tenant database, access rights of a share object in the first account, 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 second account is based on the access rights of the share object;
• generate, by the one or more processers, an alias object that references the database object of the first account and serves as a proxy of the database object;
• link the alias object to the database object;
• and
• grant the second account access rights to the alias object such that the second account access the database object using the access rights of the share objects and by way of the alias object without copying the database object.

A system comprising:

• shared storage resources for storing database data, wherein the system is a multiple tenant database system and the shared storage resources are accessible by a plurality of accounts of the multiple tenant database system;
• and
• one or more processers to:
• determine that a first account of the multiple tenant database system grants to a second account of the multiple tenant database system, access rights of a share object in the first account, 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 second account is based on the access rights of the share object;
• generate an alias object that references the database object of the first account and serves as a proxy of the database object;
• link the alias object to the database object;
• and
• grant the second account access rights to the alias object such that the second account access the database object using the access rights of the share object and by way of the alias object without copying the database object.

A method comprising:

• determining that a first account of a multiple tenant database grants to a second account of the multiple tenant database, access rights of a share object in the first account, 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 second account is based on the access rights of the share object;
• generating, by one or more processors, an alias object that references the database object of the first account and serves as a proxy of the database object;
• linking the alias object to the database object;
• and
• granting the second account access rights to the alias object such that the second account accesses the database object using the access rights of the share object and by way of the alias object without copying the database object.