Re: [HACKERS] Users specific to a Database

From: Michael Glaesemann <grzm(at)seespotcode(dot)net>
To: "Sahoo, Ranjan Rashmi" <Ranjan(dot)Sahoo(at)in(dot)unisys(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: [HACKERS] Users specific to a Database
Date: 2007-05-29 13:35:51
Message-ID: E666BE92-E867-4C86-BBDD-07259C08CDE6@seespotcode.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers


On May 29, 2007, at 6:09 , Sahoo, Ranjan Rashmi wrote:
> I am new to this postgres and now struggling with creation of a
> user specific to a database, so the user can login to that specific
> database and can do the activities as per the given credentials and
> can not touch or see any information from other databases. Can any
> one please help me in this regard?
Redirected to -general, as this is not a question that pertains to
the development of PostgreSQL.

Have you looked at pg_hba.conf? You can limit which users connect to
which databases.

http://www.postgresql.org/docs/8.2/interactive/auth-pg-hba-conf.html

Hope this helps.

Michael Glaesemann
grzm seespotcode net

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Lew 2007-05-29 13:38:09 Re: optimisation for a table with frequently used query
Previous Message Andrew Sullivan 2007-05-29 13:27:41 Re: Monitoring Tool

Browse pgsql-hackers by date

  From Date Subject
Next Message Tatsuo Ishii 2007-05-29 13:51:32 Re: What is the maximum encoding-conversion growth rate, anyway?
Previous Message Richard Huxton 2007-05-29 11:50:48 Re: [HACKERS] exit