Re: How to GRANT rights to modify a table ???

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