Thanks all
On 12/7/08, Tom Lane <[EMAIL PROTECTED]> wrote:
> "Josh Harrison" <[EMAIL PROTECTED]> writes:
>> How can I give the ALTER permission
>
> You can't grant ALTER permission --- that's only allowed to the table
> owner. However, you could make thw table be owned by a group role and
> grant
"Josh Harrison" <[EMAIL PROTECTED]> writes:
> How can I give the ALTER permission
You can't grant ALTER permission --- that's only allowed to the table
owner. However, you could make thw table be owned by a group role and
grant membership in that role.
regards, tom lane
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?
Thank
