"Raymond O'Donnell" <rod@xxxxxx> writes: > On 12/09/2009 16:44, Denis BUCHER wrote: >> ERROR: must be the owner of the mytable relation > The clue is in the error message :-) .... GRANTing ALL doesn't make them > the owner of the object as well. > For that, you have to do something like > ALTER TABLE mytable OWNER TO mycolleague; What might be more practical is to create a group role that actually owns the table, and make everyone who needs to do this sort of thing a member of that group. CREATE ROLE mytable_owner; ALTER TABLE mytable OWNER TO mytable_owner; GRANT mytable_owner TO myself, mycolleague, ... ; I highly recommend reading the GRANT command reference page. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
