Re: Limiting a user to a single or subset of databases in a cluster?

From: Christophe Pettus <xof(at)thebuild(dot)com>
To: "pgsql-general(at)postgresql(dot)org mailing list" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Limiting a user to a single or subset of databases in a cluster?
Date: 2009-09-26 18:31:33
Message-ID: E3055A06-CFD2-42AE-95AC-6BC431B09E8E@thebuild.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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(at)thebuild(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2009-09-26 18:55:34 Re: pg_buffercache - A lot of "unnamed" relfilenodes?
Previous Message Christophe Pettus 2009-09-26 18:29:16 Limiting a user to a single or subset of databases in a cluster?