"Raymond O'Donnell" <r...@iol.ie> writes:
> On 12/09/2009 16:44, Denis BUCHER wrote:
>> 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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
