| From: | "Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
|---|---|
| To: | "Shashwat_Nigam *EXTERN*" <Shashwat_Nigam(at)satyam(dot)com>, "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov> |
| Cc: | <pgsql-general(at)postgresql(dot)org>, <pgsql-sql(at)postgresql(dot)org>, <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: [GENERAL] Regarding access to a user |
| Date: | 2008-08-21 12:03:44 |
| Message-ID: | D960CB61B694CF459DCFB4B0128514C20267A8B1@exadv11.host.magwien.gv.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-general pgsql-sql |
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:
> host all all 127.0.0.1/32 md5
> host HMRI_database hmri 127.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.
> Please provide a solution for the same.
Remove the first line, and you'll be fine.
PostgreSQL uses the first line in pg_hba.conf that matches the
incoming connection.
Yours,
Laurenz Albe
| From | Date | Subject | |
|---|---|---|---|
| Next Message | dkeeney | 2008-08-21 12:35:26 | privilege shedding |
| Previous Message | Vishal Arora | 2008-08-21 09:39:43 | Re: Regarding access to a user |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Merlin Moncure | 2008-08-21 12:21:51 | Re: plpgsql - sorting result set |
| Previous Message | Ow Mun Heng | 2008-08-21 11:33:34 | Re: Interval Formatting -> Convert to timestamp |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Oliveiros Cristina | 2008-08-21 14:25:14 | Question on partitioning |
| Previous Message | Vishal Arora | 2008-08-21 09:39:43 | Re: Regarding access to a user |