Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 14BB464FD41;
	Thu, 21 Aug 2008 06:10:15 -0300 (ADT)
Received: from postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 54881-04; Thu, 21 Aug 2008 06:09:52 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from batyskaf.batory.org.pl (mail.batory.org.pl [62.89.72.199])
	by postgresql.org (Postfix) with ESMTP id EEE9664FCFC;
	Thu, 21 Aug 2008 06:07:07 -0300 (ADT)
Received: from pancernik.batory.org.pl (pancernik.batory.lan [192.168.30.210])
	(authenticated bits=0)
	by batyskaf.batory.org.pl (8.13.8/8.13.8) with ESMTP id m7L97371008624
	(version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO);
	Thu, 21 Aug 2008 11:07:03 +0200
Message-ID: <48AD3037.6060700@batory.org.pl>
Date: Thu, 21 Aug 2008 11:07:03 +0200
From: Tomasz Ostrowski <tometzky@batory.org.pl>
User-Agent: Thunderbird 2.0.0.16 (X11/20080723)
MIME-Version: 1.0
To: Shashwat_Nigam <Shashwat_Nigam@satyam.com>
CC: "pgsql-general@postgresql.org" <pgsql-general@postgresql.org>,
	"pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Subject: Re: Regarding access to a user
References: <B3F7216EEA3D5D49A0841DFC6843C33AB9BC9B@HSTMBX004.corp.satyam.ad>
	<48ABD192.EE98.0025.0@wicourts.gov>
	<B3F7216EEA3D5D49A0841DFC6843C33AB9BEEE@HSTMBX004.corp.satyam.ad>
In-Reply-To: <B3F7216EEA3D5D49A0841DFC6843C33AB9BEEE@HSTMBX004.corp.satyam.ad>
X-Enigmail-Version: 0.95.7
Content-Type: text/plain; charset=ISO-8859-2
Content-Transfer-Encoding: 7bit
X-Scanned-By: MIMEDefang 2.64 on 192.168.30.2
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none
X-Spam-Level: 
X-Archive-Number: 200808/101
X-Sequence-Number: 29946

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