Re: [GENERAL] [ADMIN] Regarding access to a user

2008-08-25 Thread Vishal Arora
> 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,

Re: [GENERAL] [ADMIN] Regarding access to a user

2008-08-25 Thread Scott Marlowe
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 acce

Re: [GENERAL] [ADMIN] Regarding access to a user

2008-08-21 Thread Albe Laurenz
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 ab

Re: [GENERAL] [ADMIN] Regarding access to a user

2008-08-21 Thread Shashwat_Nigam
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 Nigam | Software Engineer | Geographical Information System Satyam Computer Services Limited, Hyd

Re: [GENERAL] [ADMIN] Regarding access to a user

2008-08-21 Thread Tomasz Ostrowski
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 rel

Re: [GENERAL] [ADMIN] Regarding access to a user

2008-08-21 Thread Shashwat_Nigam
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, Shashwa

Re: [GENERAL] [ADMIN] Regarding access to a user

2008-08-21 Thread Tomasz Ostrowski
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.

Re: [GENERAL] [ADMIN] Regarding access to a user

2008-08-21 Thread Shashwat_Nigam
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

Re: [GENERAL] [ADMIN] Regarding access to a user

2008-08-21 Thread Shashwat_Nigam
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 HMR

Re: [GENERAL] [ADMIN] Regarding access to a user

2008-08-20 Thread Kevin Grittner
>>> 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 ne