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@xxxxxxxxxxxxx] Sent: Thursday, August 21, 2008 2:37 PM To: Shashwat_Nigam Cc: pgsql-general@xxxxxxxxxxxxxx; pgsql-admin@xxxxxxxxxxxxxx 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.
