Re: Hiding users and databases - Mailing list pgsql-general

From Andreas Kretschmer
Subject Re: Hiding users and databases
Date
Msg-id 20141018071643.GA28225@tux
Whole thread Raw
In response to Hiding users and databases  (Ross Dougherty <ross@dougherty.id.au>)
List pgsql-general
Ross Dougherty <ross@dougherty.id.au> wrote:

> Hi all,
>
> We run database servers that each contain multiple customer databases.
> We would like to give customers access to their own database but even
> though they are unable to connect to the databases of other customers
> due to connect grants they are still able to see all other databases
> and users on the server.
>
> Is there a way to mask or hide databases which they don’t have connect
> grants to and hide users/roles aside from their own? I have found some

I'm working for a hosting privider, and we are using this:

http://wiki.postgresql.org/wiki/Shared_Database_Hosting

(yeah, he is a colleague ...)



Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect.                              (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly."   (unknown)
Kaufbach, Saxony, Germany, Europe.              N 51.05082°, E 13.56889°


pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Hiding users and databases
Next
From: Dmitriy Igrishin
Date:
Subject: Re: Integrating C++ singletons into postgresql extensions???