Allowing Other Users to Alter a Table

Started by Jerry Richardsabout 14 years ago2 messagesgeneral
Jump to latest
#1Jerry Richards
jerry.richards@teotech.com

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?

Thanks Much,
Jerry

#2Scott Marlowe
scott.marlowe@gmail.com
In reply to: Jerry Richards (#1)
Re: Allowing Other Users to Alter a Table

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 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;