Thread: Bug #567: no way of restricting creation of tables

Bug #567: no way of restricting creation of tables

From
pgsql-bugs@postgresql.org
Date:
Holger Jakobs (bibjah@bg.bib.de) reports a bug with a severity of 2
The lower the number the more severe it is.

Short Description
no way of restricting creation of tables

Long Description
pg_hba.conf restricts or allows access to a database for a user.
As soon as the user has access to the database, (s)he can create
new tables without restriction.
(Access to existing tables can be restricted, but that's not the
point of this report.)
What is needed is a read-only access to a full database, thus
preventing users from creating new tables in existing databases
where they should have only read access to.

Sample Code
- not necessary, see long description
- same problem on any platform
- version 7.x

No file was uploaded with this report