Hi,
I can't rename table, if I not owner, why?
Renaming a table requires USAGE and CREATE privilege on the table schema.
My user test
ga=> \dt test1
List of tables
Schema | Name | Kind | Owner | Comment
--------+-------+-------+---------+---------
openx | test1 | table | dbadmin |
(1 row)
\dp openx
Access privileges for database "ga"
Grantee | Grantor | Privileges | Schema | Name
----------------+---------+---------------------------------------------------------------------+--------+-------
test | dbadmin | INSERT, SELECT, UPDATE, DELETE, REFERENCES, USAGE, CREATE, TRUNCATE | | openx
ALTER TABLE openx.test1 rename to test2;
ROLLBACK 3989: Must be owner of relation test1