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
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 |