How to design a database for multi Companies
487718Dec 16 2007 — edited Jul 9 2011I like to hear your comments if you have a database that serves multi companies or if you have good knowledge about this subject.
Our data is sensitive and I was thinking on creating a schema for each company but seems that's a lots of work specially when the schema will change.
Do you keep your multi companies data in one schema, if so, what kind of care we need to take to avoid any mishap??
Thanks
Mo