Thread: security

security

From
sk.list@comset.net
Date:
Hi!

I need to prevent user access to other user's database.
By default any user can connect to any database and read its scheme at least.
How to restrict this access?
User should connect to database he have access only.

SKiller
--------------------------
Sergei Keler
WebMaster of "ComSet"
E-Mail: skiller@comset.net
http://www.comset.net
--------------------------

Re: [ADMIN] security

From
Peter Eisentraut
Date:
On 2000-01-15, sk.list@comset.net mentioned:

> I need to prevent user access to other user's database.
> By default any user can connect to any database and read its scheme at least.
> How to restrict this access?
> User should connect to database he have access only.

If you are using ident "authentication" then you can do that by setting up
a different mapping file for each database. See pg_hba.conf for
details. If you're using password authentication you have to set up a
different password file for each database. See again pg_hba.conf.

--
Peter Eisentraut                  Sernanders väg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden