> Date: Mon, 25 Aug 2008 11:08:14 -0600> From: scott(dot)marlowe(at)gmail(dot)com> To: Shashwat_Nigam(at)satyam(dot)com> Subject: Re: [ADMIN] Regarding access to a user> CC: aroravishal22(at)hotmail(dot)com; pgsql-admin(at)postgresql(dot)org; Kevin(dot)Grittner(at)wicourts(dot)gov; pgsql-general(at)postgresql(dot)org; pgsql-sql(at)postgresql(dot)org> > On Thu, Aug 21, 2008 at 3:05 AM, Shashwat_Nigam> <Shashwat_Nigam(at)satyam(dot)com> 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 (pgsql-admin(at)postgresql(dot)org)> 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