Re: about seperate users in PostgreSQL

Egidijus <egidijus(dot)p(at)splius(dot)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°