database privileges and access control

From: Roman Gavrilov <romio(at)il(dot)aduva(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: database privileges and access control
Date: 2003-03-05 13:37:16
Message-ID: 3E65FD8C.3080700@il.aduva.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello,

I have 2 questions.
The first one (I know it been discussed already, but I did not find the
solution).
If I have user A and user B and database DB1 and database DB2 and only
local connections.

How can I configure the pg_hba.conf to let user A connect only to the
DB1 database and let user B connect only to the DB2 database.
The sameuser param is not good here.

local sameuser password
local all password admins

The file $PGDATA/admins contains the usernames of all users that allowed
to connect to all databases.
I tried to add next line
local DB1 password DB1_users
local DB2 password DB2_users

and added the users that allowed to connect to each database to those
files accordingly.
The user can connect to sameuser database but not to the DB1 or DB2
database with error incorrect password.

What is the problem ?

Second problem is :
How can I make users to see only the database that they own with the \l
command ?
I don't want users to see all the databases on this host but only those
that they own.

Thanks
Roman

--
-----------------------------------------------------------------------------
Roman Gavrilov
Aduva Inc., Web Development Services.
work +972-3-7534373 mobile +972-54-834668
romio(at)aduva(dot)com, romio(at)netvision(dot)net(dot)il

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Jodi Kanter 2003-03-05 13:39:08 test message
Previous Message er 2003-03-05 10:49:05 Re: problem : initdb failed