Re: Regarding access to a user

Dear Tomasz
I had done the same but still the problem is like that the user is able to access all the databases in the current server. Even the order is like same and if I comment the second line(all access) then the error is there.
Please provide solution for the same.

Thanks & Regards,
Shashwat Nigam
| Software Engineer | Geographical Information System
Satyam Computer Services Limited, Hyderabad | MOBILE: +919951467324 |

-----Original Message-----
From: Tomasz Ostrowski [mailto:tometzky(at)batory(dot)org(dot)pl]
Sent: Thursday, August 21, 2008 2:37 PM
To: Shashwat_Nigam
Cc: pgsql-general(at)postgresql(dot)org; pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] Regarding access to a user

On 2008-08-21 10:53, Shashwat_Nigam wrote:

> 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.

Order matters:
host HMRI_database hmri 127.0.0.1/32 md5
host all all 127.0.0.1/32 md5

Regards
Tometzky
--
...although Eating Honey was a very good thing to do, there was a
moment just before you began to eat it which was better than when you
were...
Winnie the Pooh

DISCLAIMER:
This email (including any attachments) is intended for the sole use of the intended recipient/s and may contain material that is CONFIDENTIAL AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or distribution or forwarding of any or all of the contents in this message is STRICTLY PROHIBITED. If you are not the intended recipient, please contact the sender by email and delete all copies; your cooperation in this regard is appreciated.