Skip site navigation (1) Skip section navigation (2)

Re: [GENERAL] Regarding access to a user

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 (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-generalpgsql-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

In response to

pgsql-sql by date

Next:From: Oliveiros CristinaDate: 2008-08-21 14:25:14
Subject: Question on partitioning
Previous:From: Vishal AroraDate: 2008-08-21 09:39:43
Subject: Re: Regarding access to a user

pgsql-admin by date

Next:From: dkeeneyDate: 2008-08-21 12:35:26
Subject: privilege shedding
Previous:From: Vishal AroraDate: 2008-08-21 09:39:43
Subject: Re: Regarding access to a user

pgsql-general by date

Next:From: Merlin MoncureDate: 2008-08-21 12:21:51
Subject: Re: plpgsql - sorting result set
Previous:From: Ow Mun HengDate: 2008-08-21 11:33:34
Subject: Re: Interval Formatting -> Convert to timestamp

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group