Re: Allow user to create tables - Mailing list pgsql-general

From Scott Marlowe
Subject Re: Allow user to create tables
Date
Msg-id Pine.LNX.4.33.0205080912040.20166-100000@css120.ihs.com
Whole thread Raw
In response to Re: Allow user to create tables  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Wed, 8 May 2002, Tom Lane wrote:

> "Tille, Andreas" <TilleA@rki.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.


pgsql-general by date:

Previous
From: "Nigel J. Andrews"
Date:
Subject: Potential problem reporting
Next
From: Barry Lind
Date:
Subject: Re: JDBC - escaping quotes?