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

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?

--
-- Christophe Pettus
    xof@thebuild.com

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