From: Vishal Arora <aroravishal22@hotmail.com>
To: Scott Marlowe <scott.marlowe@gmail.com>
To: Shashwat_Nigam <shashwat_nigam@satyam.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Cc: Kevin Grittner <kevin.grittner@wicourts.gov>
Cc: pgsql-general@postgresql.org <pgsql-general@postgresql.org>
Cc: pgsql-sql@postgresql.org <pgsql-sql@postgresql.org>
Subject: Re: Regarding access to a user
Date: Tue, 26 Aug 2008 09:48:02 +0530
Message-ID: <BLU149-W63EC5FFDFE1DB3BF499FCA9660@phx.gbl> (raw)
In-Reply-To: <dcc563d10808251008y5e9449e2gc50bc9b758b715e2@mail.gmail.com>
References: <B3F7216EEA3D5D49A0841DFC6843C33AB9BC9B@HSTMBX004.corp.satyam.ad>
<48ABD192.EE98.0025.0@wicourts.gov>
<B3F7216EEA3D5D49A0841DFC6843C33AB9BEEE@HSTMBX004.corp.satyam.ad>
<BLU149-W43C021FC87E127F8C66252A96B0@phx.gbl>
<B3F7216EEA3D5D49A0841DFC6843C33AB9BF01@HSTMBX004.corp.satyam.ad>
<dcc563d10808251008y5e9449e2gc50bc9b758b715e2@mail.gmail.com>
> Date: Mon, 25 Aug 2008 11:08:14 -0600> From: scott.marlowe@gmail.com> To: Shashwat_Nigam@satyam.com> Subject: Re: [ADMIN] Regarding access to a user> CC: aroravishal22@hotmail.com; pgsql-admin@postgresql.org; Kevin.Grittner@wicourts.gov; pgsql-general@postgresql.org; pgsql-sql@postgresql.org> > On Thu, Aug 21, 2008 at 3:05 AM, Shashwat_Nigam> <Shashwat_Nigam@satyam.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@postgresql.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=
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: aroravishal22@hotmail.com, scott.marlowe@gmail.com, shashwat_nigam@satyam.com, kevin.grittner@wicourts.gov, pgsql-general@postgresql.org, pgsql-sql@postgresql.org
Subject: Re: Regarding access to a user
In-Reply-To: <BLU149-W63EC5FFDFE1DB3BF499FCA9660@phx.gbl>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox