Home > mailing lists

ALTER TABLE .....Error: Must be owner of the table - Mailing list pgsql-general

From	Josh Harrison
Subject	ALTER TABLE .....Error: Must be owner of the table
Date	December 5, 2008 16:15:55
Msg-id	8d89ea1d0812050915j74180595if7f2ae693d82786d@mail.gmail.com Whole thread Raw
Responses	Re: ALTER TABLE .....Error: Must be owner of the table
List	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

From: "Dave Page"
Date: 05 December 2008, 15:05:58
Subject: Re: Application Stack Builder - proxy error

From: Devrim GÜNDÜZ
Date: 05 December 2008, 16:30:10
Subject: Re: Favorite Tom Lane quotes