1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2013
    Rep Power

    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
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2013
    Rep Power
    As far as I know; you cannot do this.

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

    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)

IMN logo majestic logo threadwatch logo seochat tools logo