On 12/09/2009 16:44, Denis BUCHER wrote: > 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 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; - I forget the exact syntax, but it'll be in the docs. Ray. ------------------------------------------------------------------ Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland rod@xxxxxx Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals ------------------------------------------------------------------ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
