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