Re: Is postgresql ca do the job for software deployed in

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi, Mikael,

Just my 2 cents:

Mikael Carneholm wrote:
> Do you really need to create one *DB* per client - that is, is one
> schema (in the same DB) per client out of the question?

Sometimes, schemas would work _technically_, but not politically, as a
postgresql user cannot be prevented from listing all schemas (or even
all databases in the same user), regardless whether he/she has access
rights.

But it is not always acceptable that a customer knows which other
customers one has.

This forces the use of the "one cluster per customer" paradigm.


Thanks,
Markus
-- 
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf.     | Software Development GIS

Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux