I need to create a Multi-tenant schema. I have searched a lot, but I haven't got any concrete solution to create one. Any example would be highly appreciated.
I'm using SQL-SERVER 2008.
I need to use same database for multiple clients, but I need a secure way to implement it. I have the following scenario:
I have 10 tenants, each will be having a separate TenantID. I need to provide custom UI to each user based on the TenantID of the user currently logged in. Forex: Logo, Css files all will be based on the TenantID. Can I achieve it? If yes, how? If no, then what is the alternative?