Re: about seperate users in PostgreSQL - Mailing list pgsql-general

From Andreas Kretschmer
Subject Re: about seperate users in PostgreSQL
Date
Msg-id 20120614130129.GA4788@tux
Whole thread Raw
In response to about seperate users in PostgreSQL  ("Egidijus" <egidijus.p@splius.lt>)
List pgsql-general
Egidijus <egidijus.p@splius.lt> wrote:

> Hello,
>
> How it’s possible to make that seperate users can see and control only their
> own databases when they connected to PostgreSQL server? Standard PostgreSQL
> configuration allows users to see databases of other users.
>
> In my PostgreSQL server all users have their own logins.  I’d like that users
> can connect only to their own databases (see only them). How it’s possible to
> make that in PostgreSQL?

Please read http://wiki.postgresql.org/wiki/Shared_Database_Hosting
(the author is a colleague )

AFAIK you can't avoid that users can see other databases.


Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect.                              (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly."   (unknown)
Kaufbach, Saxony, Germany, Europe.              N 51.05082°, E 13.56889°

pgsql-general by date:

Previous
From: Raghavendra
Date:
Subject: Re: Backslashitis
Next
From: Stefan Schwarzer
Date:
Subject: Error message "psql: could not connect to server: No such file or directory"