> Date: Mon, 25 Aug 2008 11:08:14 -0600> From: [EMAIL PROTECTED]> To: [EMAIL
> PROTECTED]> Subject: Re: [ADMIN] Regarding access to a user> CC: [EMAIL
> PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED];
> pgsql-general@postgresql.org; [EMAIL PROTECTED]> > On Thu, Aug 21, 2008 at
> 3:05 AM, Shashwat_Nigam> <[EMAIL PROTECTED]> wrote:> > Dear Vishal> >> >
> Thanks for the help but by doing this an error is generated at the time when>
> > the user is trying to log in with the following message:> >> > "> >> >
> Access to database denied> >> > The server doesn't grant access to the
> database: the server reports> >> > FATAL: no pg_hba.conf entry for host
> "127.0.0.1", user "hmri", database> > "postgres", SSL off> > Notice that it
> says database postgres??? User hmri doesn't have> permission to connect to
> the the postgres database. you need to> connect to the hmri database.
He is using PgAdmin III to connect to the database. When you use pgAdminIII, it
has one text field as Maintainance DB - that is by default marked as Postgres.
Now when you make entries for specific user for specific database, you get this
above error, if you do not change the maintainence db to the same as the user
wants to connect to.
>
> -- > Sent via pgsql-admin mailing list ([EMAIL PROTECTED])> To make changes
> to your subscription:> http://www.postgresql.org/mailpref/pgsql-admin
_________________________________________________________________
>From salsa lessons to filmy gossip, news to music concerts - watch it all on
>MSN Video
http://video.msn.com/?mkt=en-in
