Bug #567: no way of restricting creation of tables

From: pgsql-bugs(at)postgresql(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: Bug #567: no way of restricting creation of tables
Date: 2002-01-24 12:26:38
Message-ID: 200201241226.g0OCQc719486@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Holger Jakobs (bibjah(at)bg(dot)bib(dot)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

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2002-01-24 15:34:27 Re: Error Restoring Large Database
Previous Message Mark Rae 2002-01-24 10:12:05 Error Restoring Large Database