November 4th, 2013, 08:38 AM
Hide database to users. Please help me
Hello everybody, nice to meet you.
I'm trying to configure a, let say, shared database hosting. I have 2 users the first one the standard user postgres with full access to all databases and the second one, called st_user, able to do everything but just on db1 and not on the other existent databases. I configured everything and everything is ok but using db1 I'm still able to see other database structures (tables and fields), of course the user can't see the content of the tables, just the structure but I would definitly hide other databases.
How can I disable it? I'm in a Ubuntu Server environment.
Thanks in advance
November 5th, 2013, 07:04 AM
As far as I know; you cannot do this.
The pg_catalog holds the names of the databases and you cannot restrict access to that without breaking other things (things that are much more important than seeing other database names)