Re: create table permissions bug for 7.3.2

Evgeny Duzhakow <diabolo@philol.msu.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