Re: Hiding users and databases

On Fri, Oct 17, 2014 at 01:48:25PM +1100, Ross Dougherty 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
> methods involving modifying the system catalogs but would prefer not
> to do this. I would like to avoid renaming all users/databases to
> non-identifiable names if possible but so far I think this is my only
> option. Any other suggestions would be appreciated.

I know of now way to do this except use random strings for usernames and
database names.

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ Everyone has their own god. +