| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Evgeny Duzhakow <diabolo(at)philol(dot)msu(dot)ru> |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: create table permissions bug for 7.3.2 |
| Date: | 2003-03-13 05:55:30 |
| Message-ID: | 2387.1047534930@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
Evgeny Duzhakow <diabolo(at)philol(dot)msu(dot)ru> writes:
> I have found a bug in version 7.3.2.
> At creation of tables the user not having grants on it can create the table
> in database. (For temporary tables all works normally).
Oh?
regression=# create user z;
CREATE USER
regression=# create schema s;
CREATE SCHEMA
regression=# \c - z
You are now connected as new user z.
regression=> create table s.t (f1 int);
ERROR: s: permission denied
regression=>
I'm not seeing the problem. Please provide a test case showing that
there's a bug here.
Your patch is wrong in any case, I think, since CREATE rights on a
database control the right to create schemas, not individual tables
within schemas ...
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Evgeny Duzhakow | 2003-03-13 08:38:14 | Re: create table permissions bug for 7.3.2 |
| Previous Message | Tom Lane | 2003-03-12 21:55:50 | Re: Problem with TIME datatype |