Tom Lane a écrit : >>> 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
That's great, in fact this is the right solution, I didn't think about it... Thanks a lot... Denis -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
