Re: Regarding access to a user

From: Vishal Arora <aroravishal22(at)hotmail(dot)com>
To: Shashwat_Nigam <shashwat_nigam(at)satyam(dot)com>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Regarding access to a user
Date: 2008-08-21 08:59:20
Message-ID: BLU149-W43C021FC87E127F8C66252A96B0@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general pgsql-sql

> From: Shashwat_Nigam(at)satyam(dot)com> To: 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> Date: Thu, 21 Aug 2008 14:23:51 +0530> Subject: Re: [ADMIN] Regarding access to a user> > 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:> host all all 127.0.0.1/32 md5> host HMRI_database hmri 127.0.0.1/32 md5
You have to comment out the first entry made in your hba file. In this case it checks for the first line where all users are allowed to access all databases so it does not checks the second line.
> > 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.> > Thanks & Regards,> Shashwat Nigam> | Software Engineer | Geographical Information System> Satyam Computer Services Limited, Hyderabad | MOBILE: +919951467324 |> > -----Original Message-----> From: Kevin Grittner [mailto:Kevin(dot)Grittner(at)wicourts(dot)gov]> Sent: Wednesday, August 20, 2008 6:41 PM> To: pgsql-admin(at)postgresql(dot)org; Shashwat_Nigam> Cc: pgsql-general(at)postgresql(dot)org; pgsql-sql(at)postgresql(dot)org> Subject: Re: [ADMIN] Regarding access to a user> > >>> Shashwat_Nigam <Shashwat_Nigam(at)satyam(dot)com> 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 do is configure "host based> authentication":> > http://www.postgresql.org/docs/8.3/interactive/auth-pg-hba-conf.html> > Among other things, this allows you to restrict which users can> connect to which databases.> > -Kevin> > > DISCLAIMER:> This email (including any attachments) is intended for the sole use of the intended recipient/s and may contain material that is CONFIDENTIAL AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or distribution or forwarding of any or all of the contents in this message is STRICTLY PROHIBITED. If you are not the intended recipient, please contact the sender by email and delete all copies; your cooperation in this regard is appreciated.> > -- > Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org)> To make changes to your subscription:> http://www.postgresql.org/mailpref/pgsql-admin
_________________________________________________________________
>From salsa lessons to filmy gossip, news to music concerts - watch it all on MSN Video
http://video.msn.com/?mkt=en-in

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Shashwat_Nigam 2008-08-21 09:05:43 Re: Regarding access to a user
Previous Message Shashwat_Nigam 2008-08-21 08:53:51 Re: Regarding access to a user

Browse pgsql-general by date

  From Date Subject
Next Message Shashwat_Nigam 2008-08-21 09:05:43 Re: Regarding access to a user
Previous Message Shashwat_Nigam 2008-08-21 08:53:51 Re: Regarding access to a user

Browse pgsql-sql by date

  From Date Subject
Next Message Shashwat_Nigam 2008-08-21 09:05:43 Re: Regarding access to a user
Previous Message Shashwat_Nigam 2008-08-21 08:53:51 Re: Regarding access to a user