General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>> We are now creating an add-on product that keeps its data in sql server and plan to keep several companies in the same database with a Companies table that assigns a CompanyID for each company
>
>Hi Alejandro,
>
>A bug in your application -- unfortunately they happen -- may leak data belonging to one company to another company. Even if this seems to be an unlikely situation, you should consider it.
>
>E.g., if a company requests a backup of their data, you'll need to be sure that none else's data -- even inadvertently -- will get through.
>
>I would keep a separate database for each company. If this is not an option, at least keep companies under separate schemas. This will also allow you to separate access to data.
Hi Anatoliy, I appreciate your comment very much and will take it into account. It is still posible to keep companies in separate accounts.
Happy Holidays,
Alex
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only