Patent ID: 8392969

Claim:
A method for managing multi-tenancy database access, comprising: receiving credentials from a user associated with a first organization and a second organization, wherein the first organization is associated with a first realm of data access, and wherein the second organization is associated with a second realm of data access; validating the credentials received from the user; logging the user into an access module residing in memory upon validating the user; generating a first realm ID associated with the credentials and a first access type permitting the user access to a first predetermined set of data defined by the first realm of data access, wherein the first predetermined set of data is stored in a multi-tenancy data repository; generating a second realm ID associated with the credentials and a second access type permitting the user access to a second predetermined set of data defined by the second realm of data access, wherein the second predetermined set of data is stored in the multi-tenancy data repository; storing the first realm ID, the second realm ID, and the credentials in an authentication module; generating a connection request after storing the first realm ID, the second realm ID, and the credentials; establishing a connection from the access module to the multi-tenancy data repository based on the connection request; generating a first identifier associated with the first realm ID and a second identifier associated with the second realm ID after establishing the connection; storing the first identifier, the first realm ID, the second identifier, and the second realm ID in the multi-tenancy data repository; receiving a single write request to perform a write operation on both the first predetermined set of data and the second predetermined set of data from the user; performing a verification of the single write request based on the first identifier, the second identifier, the first access type, and the second access type; approving the single write request based on the verification of the single write request; and performing the write operation on the first predetermined set of data and the second predetermined set of data in the multi-tenancy data repository after approval of the single write request.