Re: [ADMIN] [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: [ADMIN] [SQL] Thoughts on a Isolation/Security problem.

2006-04-18 Thread Andy Shellam
  From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Luckys Sent: 18 April 2006 10:59 am To: Achilleus Mantzios Cc: pgsql-sql@postgresql.org; pgsql-admin@postgresql.org; pgsql-general@postgresql.org; pgsql-jdbc@postgresql.org Subject: Re: [ADMIN] [SQL] Thoughts on a Isolation

Re: [ADMIN] [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