On Thu, 13 Mar 2003, Tom Lane wrote:
TL>regression=# create user z;
TL>CREATE USER
TL>regression=# create schema s;
TL>CREATE SCHEMA
TL>regression=# \c - z
TL>You are now connected as new user z.
TL>regression=> create table s.t (f1 int);
TL>ERROR: s: permission denied
TL>regression=>
TL>I'm not
Evgeny Duzhakow <[EMAIL PROTECTED]> writes:
> Now connect and try to create the table:
> testtables=# \c - fake
> You are now connected as new user fake.
> testtables=> create table qq(i int);
> CREATE TABLE
Sure. You need to revoke CREATE access on the public schema (not the
same thing as the
Evgeny Duzhakow <[EMAIL PROTECTED]> 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;
CREA
