How to GRANT rights to modify a table ??? - Mailing list pgsql-general

From Denis BUCHER
Subject How to GRANT rights to modify a table ???
Date
Msg-id 4AABC1E5.7060405@hsolutions.ch
Whole thread Raw
Responses Re: How to GRANT rights to modify a table ???  (Raymond O'Donnell <rod@iol.ie>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Clodoaldo Neto
Date:
Subject: Missing 8.2.14 source rpms
Next
From: Raymond O'Donnell
Date:
Subject: Re: How to GRANT rights to modify a table ???