Thread: Allowing Other Users to Alter a Table

I'm getting this error:

"Error executing SQL ALTER TABLE ts_core.calls ALTER COLUMN call_uuid TYPE VARCHAR(255): ERROR: must be owner of
relationcalls" 

Is there a way that I can configure postgresql so that it allows other users to alter this table?

Thanks Much,
Jerry

On Tue, Mar 13, 2012 at 10:07 AM, Jerry Richards
<jerry.richards@teotech.com> wrote:
> I'm getting this error:
>
> "Error executing SQL ALTER TABLE ts_core.calls ALTER COLUMN call_uuid TYPE VARCHAR(255): ERROR: must be owner of
relationcalls" 
>
> Is there a way that I can configure postgresql so that it allows other users to alter this table?

You can grant a role to another role.  So if user a created the table,
and you want user b to be able to play with user a created tables,
then:

grant a to b;