Bug #567: no way of restricting creation of tables - Mailing list pgsql-bugs

From pgsql-bugs@postgresql.org
Subject Bug #567: no way of restricting creation of tables
Date
Msg-id 200201241226.g0OCQc719486@postgresql.org
Whole thread Raw
List pgsql-bugs
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

pgsql-bugs by date:

Previous
From: Mark Rae
Date:
Subject: Error Restoring Large Database
Next
From: Tom Lane
Date:
Subject: Re: Error Restoring Large Database