Shashwat_Nigam wrote: > Thanks for the help. But still the user is able to see all > the databases. I defined something like this > > # IPv4 local connections: > host all all 127.0.0.1/32 md5 > host HMRI_database hmri 127.0.0.1/32 md5 > > > in the above case hmri is user and HMRI_database. But still > when user is log in as 'hmri' it is able to access all the databases. > Please provide a solution for the same. Remove the first line, and you'll be fine. PostgreSQL uses the first line in pg_hba.conf that matches the incoming connection. Yours, Laurenz Albe
