Re: [SQL] Thoughts on a Isolation/Security problem.

2006-04-18 Thread Achilleus Mantzios
O Luckys έγραψε στις Apr 18, 2006 : > how about having a company table, and company_code column across all > relevant table, although you'll have to modify your application also, which > would be an additional clause in the WHERE condition e.g where company_code > = 'which company user has logged

Re: [SQL] Thoughts on a Isolation/Security problem.

2006-04-18 Thread Luckys
how about having a company table, and company_code column across all relevant table, although you'll have to modify your application also, which would be an additional clause in the WHERE condition e.g where company_code = 'which company user has logged in'. The user has to specify while logging u

[SQL] Thoughts on a Isolation/Security problem.

2006-04-18 Thread Achilleus Mantzios
Hi, i have run into the following problem. Let me describe the context first. When i joined the company(ies) i work for (a group of Shipping Mgmt/ Owenship/Agent companies), the only thing i was told when i started designing the DB/Apps was just one company. So i built everything into one single