From: Kevin Grittner <Kevin.Grittner@wicourts.gov>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
To: Shashwat_Nigam <Shashwat_Nigam@satyam.com>
Cc: pgsql-general@postgresql.org <pgsql-general@postgresql.org>
Cc: pgsql-sql@postgresql.org <pgsql-sql@postgresql.org>
Subject: Re: Regarding access to a user
Date: Wed, 20 Aug 2008 08:10:59 -0500
Message-ID: <48ABD192.EE98.0025.0@wicourts.gov> (raw)
In-Reply-To: <B3F7216EEA3D5D49A0841DFC6843C33AB9BC9B@HSTMBX004.corp.satyam.ad>
References: <B3F7216EEA3D5D49A0841DFC6843C33AB9BC9B@HSTMBX004.corp.satyam.ad>
>>> Shashwat_Nigam <Shashwat_Nigam@satyam.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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: Kevin.Grittner@wicourts.gov, Shashwat_Nigam@satyam.com, pgsql-general@postgresql.org, pgsql-sql@postgresql.org
Subject: Re: Regarding access to a user
In-Reply-To: <48ABD192.EE98.0025.0@wicourts.gov>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox