Postgres Pro
Downloads
Home   >   mailing lists

Re: Limiting a user to a single or subset of databases in a cluster? - Mailing list pgsql-general

From Christophe Pettus
Subject Re: Limiting a user to a single or subset of databases in a cluster?
Date
Msg-id E3055A06-CFD2-42AE-95AC-6BC431B09E8E@thebuild.com
Whole thread Raw
In response to Limiting a user to a single or subset of databases in a cluster?  (Christophe Pettus <xof@thebuild.com>)
List pgsql-general
Tree view 
On Sep 26, 2009, at 11:29 AM, Christophe Pettus wrote:
> Of course, one can create a user that has no useful privileges on a
> particular database, but is there a way of limiting a user to being
> able to log into only a single one of, or a subset of, the databases
> in a cluster?


Like, say GRANT / REVOKE CONNECT ON database TO role, just for
example?  Never mind!

--
-- Christophe Pettus
   xof@thebuild.com

pgsql-general by date:

Previous
From: Christophe Pettus
Date:
Subject: Limiting a user to a single or subset of databases in a cluster?
Next
From: Tom Lane
Date:
Subject: Re: pg_buffercache - A lot of "unnamed" relfilenodes?