Re: Can I grant permissions to specific set of uids (linux) ?

Поиск

Список

Период

Сортировка

От	David G. Johnston
Тема	Re: Can I grant permissions to specific set of uids (linux) ?
Дата	7 марта 2018 г. 03:33:44
Msg-id	CAKFQuwZfPphBimfb+gWFTQkiuV8zLT8iE8QzxLwUxBU6igtoQw@mail.gmail.com обсуждение исходный текст
Ответ на	Can I grant permissions to specific set of uids (linux) ? (David Gauthier <davegauthierpg@gmail.com>)
Список	pgsql-general

Дерево обсуждения

On Tue, Mar 6, 2018 at 1:26 PM, David Gauthier <davegauthierpg@gmail.com> wrote:

Hi:

I'd like to grant select, insert, update, delete to a table for a specific set of uids (linux). All others get select only. Can the DB authenticate the current linux user and grant access based on the fact that they are logged in ()IOW, no passwords ? Is this possible ? If so, how ?

see

https://www.postgresql.org/docs/10/static/auth-methods.html#AUTH-PEER

Note it authenticates by the name, not the numeric value.

If that doesn't cover your need the answer to your question is probably no.

David J.

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