Skip to main content
Software Engineering

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

3
  • 1
    "multi tenant" implies strong security - implemented somewhere - so that one tenant can't see other's data, can't modify it, can't deny access to it, etc. That security has to be implemented somehow. Options #1 and #2 of the OP both work but the security analysis and the work required to implement security is different. For what it's worth, I worked at a startup that implemented multi-tenancy via option #2 where the tables - with rows belonging to multiple tenants - were hidden (via permissions) from all end users and security was implemented entirely in stored procedures. Commented Jan 19, 2017 at 22:32
  • 3
    Possible duplicate of Multi-tenancy - single database vs multiple database Commented Jan 20, 2017 at 11:33
  • 1
    If this ends up being closed as a duplicate, I think we should flag to merge it with the dupe target because both questions have some really good answers. Commented Jan 24, 2017 at 15:46