A method for managing multi-tenancy database access, including receiving credentials from a user associated with a first organization and a second organization, validating the credentials received from the user, logging the user into an access module, generating a first realm ID associated with the credentials and a first access type, generating a second realm ID associated with the credentials and a second access type, storing the first realm ID, the second realm ID, and the credentials in an authentication module, generating a connection request, establishing a connection from the access module to a 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; and storing the first identifier, the first realm ID, the second identifier, and the second realm ID in the data repository.