restricting non superuser from accessing other databases

From: David Garamond <lists(at)zara(dot)6(dot)isreserved(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: restricting non superuser from accessing other databases
Date: 2004-09-07 10:28:44
Message-ID: 413D8D5C.5030403@zara.6.isreserved.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I am setting up a single PostgreSQL installation to be used by several
users. Can I restrict a database user from connecting and creating
objects in other databases but his/her own? So far I can only restrict a
user from creating more databases or users.

(Yes, I have set up a proper pg_hba.conf, but once a user is connected,
he can switch to another database, e.g. with "\c otherdb" in psql).

--
dave

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Devrim GUNDUZ 2004-09-07 10:31:55 Re: postgres 8 performance
Previous Message Chris Mair 2004-09-07 10:27:59 Re: postgres 8 performance