Re: restricting non superuser from accessing other databases

Oliver Elphick wrote:
>>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).
>
> Not unless pg_hba.conf allows it.  You could set up explicit
> database/user combinations there.

Thanks! So I must modify and kill -HUP postmaster everytime a new db is
added. Is there something like this in pg_hba.conf?

  local owndb all md5

where "owndb" means only allow a user to connect only to db he/she owns.

--
dave