Re: Two databases on the same server, looking for idea how to restrict access. - Mailing list pgsql-general

From René Romero Benavides
Subject Re: Two databases on the same server, looking for idea how to restrict access.
Date
Msg-id 4FD22E73.50406@gmail.com
Whole thread Raw
In response to Re: Two databases on the same server, looking for idea how to restrict access.  (Darren Duncan <darren@darrenduncan.net>)
List pgsql-general
Am 07.06.2012 23:03, schrieb Darren Duncan:
Raymond O'Donnell wrote:
On 07/06/2012 15:39, Condor wrote:
I have two databases on postgresql in different servers, one main
database and one secondary not much important,
but the problem is they should use some tables both for reading and
writing and the secondary postgresql should not
have access to whole database on the main database. Im thinking to
combine both databases on same server and split them
with different schema also to make load balance and some kind of
permissions to restrict secondary database to read whole
database on the main database or some kind of shared tables (files). Any
one have some ideas how I can do this ? Any ideas is welcome.

Your idea of two schemas in the one database is the way to go - you
cannot share tables between different databases.

Further to this point, make sure you have a different database user for each of the people or applications you want to service, give the two schemas different owners or do appropriate privilege granting in the database, to keep each person/application to just the things they should see and nothing else. -- Darren Duncan

For that sort of thing you might use dblink as well, but the separate schemas idea is way simpler and effective.
http://www.postgresql.org/docs/current/static/dblink.html
--
pglearn.blogspot.mx:postgresql recipes
Twitter.You might consider to follow @sqlhotfix

pgsql-general by date:

Previous
From: Keith Fiske
Date:
Subject: Extension table data
Next
From: "Little, Douglas"
Date:
Subject: describe command for