On 18.02.2024 15:19, Dominique Devienne wrote:
On Sun, Feb 18, 2024 at 12:30 PM Laurenz Albe <
laurenz.albe@cybertec.at> wrote:
2. In PostgreSQL, there is the important concept of ownership, which is not tied to the schema.
The owner is the user who created the object.
Personally I find that confusing. I wouldn't mind schema objects all belonging to the one owner.
Or being to enforce that, as an opt-in option. Not sure what's the benefits of different owners for a schemas objects are.
The situation is even more confusing :-)
Roles with membership in object owner role acts as an owner.
For example they can modify or drop object or grant/revoke access to object.
--
Pavel Luzanov
Postgres Professional: https://postgrespro.com