From: | Thomas Jacob <jacob(at)internet24(dot)de> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Best practice running a shared DB hosting server |
Date: | 2008-08-13 13:44:57 |
Message-ID: | 1218635097.28547.28.camel@enterprise.ims-firmen.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hello List,
I was wondering if there is something like
a best practice document for running
PostgreSQL (probably 8.3.3) securely in a shared
Web+DB hosting environment, where different
people without any administrative relationship
between them may run their databases on
the same server.
I am particularly interested in the
role, permission and schema layout.
Also I'm worried about the amount of information
available to ordinary DB users. For instance,
without revoking access to pg_catalog from
PUBLIC all users can see the usernames,
database names etc. of all other users. But
revoking the right from pg_catalog doesn't
seem to be an option, as this breaks
several features of the psql utility and probably
other things.
Thanks & Best Regards,
Thomas
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Marlowe | 2008-08-13 14:57:39 | Re: Best practice running a shared DB hosting server |
Previous Message | Dey, Sutapa | 2008-08-13 04:30:15 | URGENT HELP NEEDED: To enable pgsql support in HP-UX 11.23 Itanium |