Re: Users and object privileges maintenance

Поиск
Список
Период
Сортировка
От Dominique Devienne
Тема Re: Users and object privileges maintenance
Дата
Msg-id CAFCRh-_-x0Xg--hdKMuTa=x1XqVkVJuPEMY2vdGXFwsd5ipf2Q@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Users and object privileges maintenance  (Pavel Luzanov <p.luzanov@postgrespro.ru>)
Ответы Re: Users and object privileges maintenance
Список pgsql-general
On Sun, Feb 18, 2024 at 3:27 PM Pavel Luzanov <p.luzanov@postgrespro.ru> wrote:
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 [able] 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.

Well, membership in a role mean you can "become that role", no? Thus this seems logical,
and not confusing to me, that you can act as the owner, since you SET ROLE to the owner.
Or am I missing something else? --DD

В списке pgsql-general по дате отправления:

Предыдущее
От: Pavel Luzanov
Дата:
Сообщение: Re: Users and object privileges maintenance
Следующее
От: Pavel Luzanov
Дата:
Сообщение: Re: Users and object privileges maintenance