在更改所有者对象时，“ must be owner of relations”错误

我需要给当前用户(“ 用户 A”)什么样的 grant选项/技巧来允许他更改属于另一个用户(“ 用户 C”)的对象的所有者？

更准确地说，接触表由 用户 C所有，当我执行以下查询将所有者更改为与 用户 A连接的 用户 B时:

alter table contact owner to userB;

我得到了这个错误:

ERROR:  must be owner of relation contact

但是，用户 A拥有所有通常需要的权利(“ 在模式上创建”赠款选项应该足够了) :

grant select,insert,update,delete on all tables in schema public to userA;
grant select,usage,update on all sequences in schema public to userA;
grant execute on all functions in schema public to userA;
grant references, trigger on all tables in schema public to userA;
grant create on schema public to userA;
grant usage on schema public to userA;

谢谢

命令行输出:

root@server:~# psql -U userA myDatabase
myDataBase=>\dt contact
List of relations
Schema |  Name   |   Type   |  Owner
-------+---------+----------+---------
public | contact | table    | userC
(1 row)
myDataBase=>
myDataBase=>alter table contact owner to userB;
ERROR:  must be owner of relation public.contact
myDataBase=>

186653

小开

From the fine manual.

You must own the table to use ALTER TABLE.

Or be a database superuser.

ERROR: must be owner of relation contact

PostgreSQL error messages are usually spot on. This one is spot on.

小开

最佳答案

Thanks to Mike's comment, I've re-read the doc and I've realised that my current user (i.e. userA that already has the create privilege) wasn't a direct/indirect member of the new owning role...

So the solution was quite simple - I've just done this grant:

grant userB to userA;

That's all folks ;-)

Update:

Another requirement is that the object has to be owned by user userA before altering it...

小开

This solved my problem: an ALTER TABLE statement to change the ownership.

ALTER TABLE databasechangelog OWNER TO arwin_ash;
ALTER TABLE databasechangeloglock OWNER TO arwin_ash;

小开

For me, I had to give ownership of the complete database. and that was the case when I tried to run migrate (py manage.py migrate) in Django

how I did that, in PostgreSQL shell, please run this command:

ALTER DATABASE <name> OWNER TO <user>;