Re: Allow user to create tables

From: Scott Marlowe <scott(dot)marlowe(at)ihs(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Tille, Andreas" <TilleA(at)rki(dot)de>, PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Allow user to create tables
Date: 2002-05-08 15:13:35
Message-ID: Pine.LNX.4.33.0205080912040.20166-100000@css120.ihs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, 8 May 2002, Tom Lane wrote:

> "Tille, Andreas" <TilleA(at)rki(dot)de> writes:
> > test=> drop table test;
> > ERROR: you do not own table "test"
>
> > Did I miss something?
>
> No. What is not clear about that error message? Only the owner can
> drop a table. It's not considered a grantable right.

But it is something you can change. As the table owner or superuser,
Andreas, you can issue the following command:

alter table ttt owner to somebody;

There ya go.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Randall Perry 2002-05-08 16:03:48 Re: Can this be done in one query?
Previous Message Nigel J. Andrews 2002-05-08 15:02:59 Potential problem reporting