Re: Allow user to create tables

On Tue, 7 May 2002, Tom Lane wrote:

> "Tille, Andreas" <TilleA@rki.de> writes:
> > I just created a database and granted all rights to the tables I created to
> > an additional user.  I observed that this user does not have the right to
> > create additional tables.
>
> I think you have that backwards ;-).  In PG you *cannot prevent* a user
> from being able to create tables.
>
> 7.3 will have permissions that control this, but no extant release does.
Sorry, forget about my previous mail which I claimed that PgAdmin2
was causing trouble.

~> whoami
databaseowner
~> psql test
...
test=# create table test (i int, t varchar(17) );
CREATE
test=# grant all on test to testuser ;
GRANT
test=# \q

~> su testuser
...
~> psql test
test=> drop table test;
ERROR:  you do not own table "test"

Did I miss something?

Kind regards

         Andreas.