Sharing information between tenants of a multi-tenant database

A computer-readable storage medium having one or more instructions thereon for sharing information between tenants in a multi-tenant database, the instructions when executed by one or more processors causing the one or more processors to carry out:

• receiving information on a connection between a first tenant of a multi-tenant database and a second tenant, wherein the connection comprises information on a scope of data from the first tenant shared with the second tenant;
• allowing data for a record of the first tenant to be accessible to the second tenant in accordance with the connection;
• receiving information on a file related to the record of the first tenant;
• and
• allowing data from the file to be accessible to the second tenant in accordance with the connection.

A system for optimizing a query in a database system, the system comprising:

• a processor;
• and
• one or more stored sequences of instructions which, when executed by the processor, cause the processor to carry out:
• receiving information on a connection between a first tenant of a multi-tenant database and a second tenant, wherein the connection comprises information on a scope of data from the first tenant shared with the second tenant;
• allowing data for a record of the first tenant to be accessible to the second tenant in accordance with the connection;
• receiving information on a file related to the record of the first tenant;
• and
• allowing data from the file to be accessible to the second tenant in accordance with the connection.