XGIS
asked on
Isolated and shared multi-tenancy
Hello Experts,
I am writing this question to get some advice..... I am in the process of creating an isolated and shared multi tenancy db solution (I hope I am using the correct terms) and the issue I am currently facing is the management of users and schema's.... what i have is a customers db, accounting db, assets db, projects db, ecommerce db and configuration db... where each db (except the config db) has its own web application that is hosted via a portal..... the problem, when a user goes to my site and purchases 3 months access to say 3 of the apps should I have there details stored in the ecommerce system and when payment is confirmed should I use a stored proceedure to create the schemas and record the companies schema and db access to the configuration db???? and if this is the case how should I manage the employees unter a company as they need to be able to be created by the designated sys admin....????
xTremeBMS-multi-tennant.png
I am writing this question to get some advice..... I am in the process of creating an isolated and shared multi tenancy db solution (I hope I am using the correct terms) and the issue I am currently facing is the management of users and schema's.... what i have is a customers db, accounting db, assets db, projects db, ecommerce db and configuration db... where each db (except the config db) has its own web application that is hosted via a portal..... the problem, when a user goes to my site and purchases 3 months access to say 3 of the apps should I have there details stored in the ecommerce system and when payment is confirmed should I use a stored proceedure to create the schemas and record the companies schema and db access to the configuration db???? and if this is the case how should I manage the employees unter a company as they need to be able to be created by the designated sys admin....????
xTremeBMS-multi-tennant.png
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Message to the moderator...., please can the image attached to the question be removed from the server???
ASKER