Hello,
A very annoying problem with Postgres is the following one :
As postgres user, I give all rights to all objects of a database or
schema to a colleague :
GRANT ALL ON mytable TO mycolleague;
But when he tries to modify something, even something really small like
adding a column to a table :
ALTER TABLE mytable ADD COLUMN field integer;
ERROR: must be the owner of the mytable relation
Therefore, how to give right to some user on tables structure ???
Thanks a lot for any help, this problem is always giving us lots of
difficulties...
Denis