Re: Allowing Other Users to Alter a Table

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Jerry Richards <jerry(dot)richards(at)teotech(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Allowing Other Users to Alter a Table
Date: 2012-03-13 16:23:15
Message-ID: CAOR=d=3NVn82U8f-=TGg-HH4ZKePX+Xu12jPgNjSRqR23JKCsQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Mar 13, 2012 at 10:07 AM, Jerry Richards
<jerry(dot)richards(at)teotech(dot)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 relation calls"
>
> 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;

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Carson Gross 2012-03-13 16:43:16 Re: Upgrade questions
Previous Message Jerry Richards 2012-03-13 16:07:53 Allowing Other Users to Alter a Table