On Tue, Mar 13, 2012 at 10:07 AM, Jerry Richards <jerry.richa...@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; -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
