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

Re: Regarding access to a user

From: Shashwat_Nigam <Shashwat_Nigam(at)satyam(dot)com>
To: Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>, "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Regarding access to a user
Date: 2008-08-21 08:53:51
Message-ID: B3F7216EEA3D5D49A0841DFC6843C33AB9BEEE@HSTMBX004.corp.satyam.ad (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-generalpgsql-sql
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


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.

In response to

Responses

pgsql-sql by date

Next:From: Vishal AroraDate: 2008-08-21 08:59:20
Subject: Re: Regarding access to a user
Previous:From: Mike ToewsDate: 2008-08-20 19:47:14
Subject: Re: order function in aggregate

pgsql-admin by date

Next:From: Vishal AroraDate: 2008-08-21 08:59:20
Subject: Re: Regarding access to a user
Previous:From: Peter KovacsDate: 2008-08-21 07:08:33
Subject: Re: Readline support in psql -- worked earlier for me

pgsql-general by date

Next:From: Vishal AroraDate: 2008-08-21 08:59:20
Subject: Re: Regarding access to a user
Previous:From: Tomasz OstrowskiDate: 2008-08-21 08:45:30
Subject: Re: Single character bitfields

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