Re: [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]; pgsql-admin@postgresql.org; [EMAIL PROTECTED]; [EMAIL PROTECTED]; > [EMAIL PROTECTED]> > O

Re: [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: [ADMIN] Regarding access to a user

2008-08-25 Thread Lew
Shashwat_Nigam wrote: Dear Tomasz There are others here, too. 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 p

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: [ADMIN] Regarding access to a user

2008-08-21 Thread Vishal Arora
From: [EMAIL PROTECTED]: [EMAIL PROTECTED]; [EMAIL PROTECTED]: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]: Thu, 21 Aug 2008 14:55:05 +0530Subject: Re: [ADMIN] Regarding access to a user Hi Vishal Ya you are right and the order is same and the command is like that only

Re: [ADMIN] Regarding access to a user

2008-08-21 Thread Shashwat_Nigam
ww.satyam.com/>, Hyderabad | MOBILE: +919951467324 | From: Vishal Arora [mailto:[EMAIL PROTECTED] Sent: Thursday, August 21, 2008 2:47 PM To: Shashwat_Nigam; pgsql-admin@postgresql.org Subject: RE: [ADMIN] Regarding access to a user Hi Shashwat, I presume your user is hmri and the database is hmri

Re: [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: [ADMIN] Regarding access to a user

2008-08-21 Thread Vishal Arora
yderabad | MOBILE: +919951467324 | From: Vishal Arora [mailto:[EMAIL PROTECTED] Sent: Thursday, August 21, 2008 2:29 PMTo: Shashwat_NigamCc: [EMAIL PROTECTED]: RE: [ADMIN] Regarding access to a user > From: [EMAIL PROTECTED]> To: [EMAIL PROTECTED]> CC: [EMAIL PROTECTED]; [EMAIL

Re: [ADMIN] Regarding access to a user

2008-08-21 Thread Shashwat_Nigam
gsql-admin@postgresql.org Subject: Re: [ADMIN] Regarding access to a 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. B

Re: [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: [ADMIN] Regarding access to a user

2008-08-21 Thread Shashwat_Nigam
Computer Services Limited<http://www.satyam.com/>, Hyderabad | MOBILE: +919951467324 | From: Vishal Arora [mailto:[EMAIL PROTECTED] Sent: Thursday, August 21, 2008 2:29 PM To: Shashwat_Nigam Cc: pgsql-admin@postgresql.org Subject: RE: [ADMIN] Regarding access to a user

Re: [ADMIN] Regarding access to a user

2008-08-21 Thread Vishal Arora
> From: [EMAIL PROTECTED]> To: [EMAIL PROTECTED]> CC: [EMAIL PROTECTED]; [EMAIL > PROTECTED]; pgsql-admin@postgresql.org> Date: Thu, 21 Aug 2008 14:23:51 > +0530> Subject: Re: [ADMIN] Regarding access to a user> > Dear Kevin> Thanks > for the help. But stil

Re: [ADMIN] Regarding access to a user

2008-08-21 Thread Shashwat_Nigam
+919951467324 | -Original Message- From: Kevin Grittner [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 20, 2008 6:41 PM To: pgsql-admin@postgresql.org; Shashwat_Nigam Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: [ADMIN] Regarding access to a user >>> Shashwat_Nigam <[EMAIL

Re: [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

[ADMIN] Regarding access to a user

2008-08-20 Thread Shashwat_Nigam
Dear Team First of all I would like to thank you to provide a spatial database fro GIS developers and user. But I have doubt in the usage. I have created a few databases (i.e. X, Y, Z) in a default Server and I also created a user (i.e. Us). Now what I want is to set privilege that whenever th