Search Postgresql Archives

How to GRANT rights to modify a table ???

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux