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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Josh Harrison" <joshques(at)gmail(dot)com>
Cc: "General postgres mailing list" <pgsql-general(at)postgresql(dot)org>
Subject: Re: ALTER TABLE .....Error: Must be owner of the table
Date: 2008-12-07 22:31:38
Message-ID: 18932.1228689098@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Josh Harrison" <joshques(at)gmail(dot)com> 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bill Todd 2008-12-08 00:13:50 Re: COPY error with null date
Previous Message Harvey, Allan AC 2008-12-07 22:15:05 Re: tuples