Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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


pgsql-bugs by date

Next:From: Tom LaneDate: 2002-01-24 15:34:27
Subject: Re: Error Restoring Large Database
Previous:From: Mark RaeDate: 2002-01-24 10:12:05
Subject: Error Restoring Large Database

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group