System, method and computer program product for sharing a single instance of a database stored using a tenant of a multi-tenant on-demand database system

摘要

In accordance with embodiments, there are provided mechanisms and methods for sharing a single instance of a database stored using a tenant of a multi-tenant on-demand database system. These mechanisms and methods for sharing a single instance of a database stored using a tenant of a multi-tenant on-demand database system can provide a single instance of a database that is shared amongst tenants of a multi-tenant on-demand database system. The ability to provide a single instance of a database that is shared amongst tenants of a multi-tenant on-demand database system can enable the database to be managed or otherwise maintained in a central location.

主权项

1. A computer program product embodied on a non-transitory computer readable medium, the computer program product including computer code adapted to be executed by a computer to perform a method comprising:
storing a database used by a first tenant of a multi-tenant on-demand database system by storing the database in a location in memory of the multi-tenant on-demand database system that is dedicated to only the first tenant; and allowing at least one second tenant of the multi-tenant on-demand database system to access the database, such that:
the at least one second tenant of the multi-tenant on-demand database system is allowed to perform one or more queries on the database for retrieving data stored in the database,the first tenant is able to alter data stored in the database, andthe at least one second tenant is prevented from altering the data stored in the database.