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