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
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,
Dear Kevin
Thanks for the help. But still the user is able to see all the databases. I
defined something like this
# IPv4 local connections:
hostall all 127.0.0.1/32 md5
hostHMRI_database hmri127.0.0.1/32 md5
in the above case hmri is user and
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
On 2008-08-21 10:53, Shashwat_Nigam wrote:
hostall all 127.0.0.1/32 md5
hostHMRI_database hmri127.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.
Dear Tomasz
I had done the same but still the problem is like that the user is able to
access all the databases in the current server. Even the order is like same and
if I comment the second line(all access) then the error is there.
Please provide solution for the same.
Thanks Regards,
On 2008-08-21 11:12, Shashwat_Nigam wrote:
I had done the same but still the problem is like that the user is
able to access all the databases in the current server. Even the
order is like same and if I comment the second line(all access) then
the error is there.
You did issue pg_ctl reload
Hi Vishal
Ya you are right and the order is same and the command is like that only.
I am opening it through pgAdmin only..
Thanks Regards,
Shashwat Nigammailto:[EMAIL PROTECTED]
| Software Engineer | Geographical Information System
Satyam Computer Services Limitedhttp://www.satyam.com/,
Shashwat_Nigam wrote:
Thanks for the help. But still the user is able to see all
the databases. I defined something like this
# IPv4 local connections:
hostall all 127.0.0.1/32 md5
hostHMRI_database hmri127.0.0.1/32 md5
in the above case
Shashwat_Nigam [EMAIL PROTECTED] wrote:
Now what I want is to set privilege that whenever the user log in as
Us
he can only see database Y, none other than that. The user Us could
have all
rights for database Y but can't go for any other database (X or Z).
The first thing you need to
10 matches
Mail list logo