ALTER TABLE .....Error: Must be owner of the table

From: "Josh Harrison" <joshques(at)gmail(dot)com>
To: "General postgres mailing list" <pgsql-general(at)postgresql(dot)org>
Subject: ALTER TABLE .....Error: Must be owner of the table
Date: 2008-12-05 17:15:48
Message-ID: 8d89ea1d0812050915j74180595if7f2ae693d82786d@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,
I had created some tables in the schema Foo and given
GRANT ALL ON SCHEMA FOO TO SCOT;

But when Scot tries to alter a table he gets the error
MUST BE OWNER OF THE TABLE

How can I give the ALTER permission or is there any other way to let other
users modify or add tables in this schema?

Thanks
Josh

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Devrim GÜNDÜZ 2008-12-05 17:30:52 Re: Favorite Tom Lane quotes
Previous Message Dave Page 2008-12-05 16:03:30 Re: Application Stack Builder - proxy error