From: Thomas Mack <mack@ifis.cs.tu-bs.de>
To: pgsql-admin@postgresql.org
Subject: Role based database access
Date: Thu, 24 May 2007 10:42:40 +0200
Message-ID: <200705241042.40007.mack@ifis.cs.tu-bs.de> (raw)
Hello!
I face a problem here with restricting access to databases to
the owners of the database (Postgres 8.1.4).
We would like any postgres user to have database access restricted
to their own databases only. This is so, as we use postgres for
educational purposes.
I looked into pg_hba.conf, but unfortunately, when restricting
database access in the database field, the NAME(!) of the database
is concerned, which we do not restrict. Any user can create as
many databases as needed, and the name may be choosen freely.
The 'user' field does not help in this either.
So is there any chance to achieve what we need without revoking
the 'create database' permission and pre-creating the databases
for all our users?
Thanks,
Thomas Mack
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: mack@ifis.cs.tu-bs.de
Subject: Re: Role based database access
In-Reply-To: <200705241042.40007.mack@ifis.cs.tu-bs.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox