Sample Header Ad - 728x90

Why the owner of a database can't alter the tables of this database that are owned by other owners?

2 votes
1 answer
987 views
For now I don't understand why this access rights segregation exist. Is it implemented for some security reasons? Or can it be needed by some use cases I can't imagine right now? Knowing almost nothing about the reasons behind concrete PostgreSQL design I wonder why prevent a database owner from altering those tables of the database owned that are owned by other owners. Here's what [the official documentation on altering tables](https://www.postgresql.org/docs/10/static/sql-altertable.html) says regarding who can alter tables of a database: > You must own the table to use ALTER TABLE. Of course I don't argue the design or the documentation. I'm just wondering why it can be needed to limit a database owner that way?
Asked by Alexander Ites (121 rep)
Feb 14, 2018, 01:42 PM
Last activity: May 14, 2024, 03:04 PM