Link to home
Start Free TrialLog in
Avatar of XGIS
XGISFlag for Australia

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
ASKER CERTIFIED SOLUTION
Avatar of Lowfatspread
Lowfatspread
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of XGIS

ASKER

Not the response I was expecting but still gave me some ideas
Avatar of XGIS

ASKER

Message to the moderator...., please can the image attached to the question be removed from the server???