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

Поиск
Список
Период
Сортировка
От Melvin Davidson
Тема Re: Can I grant permissions to specific set of uids (linux) ?
Дата
Msg-id CANu8FizTKdo_0xbo9=P1P7036s+w=x+Rg+2GSp+=XwaqnX74Cg@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 3: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 ?

Thanks for any help
 
> I'd like to grant select, insert, update, delete to a table for a specific set of uids (linux).

PostgreSQL does not allow permissions based on uid's.
The accepted/implemented way of doing that is to:
1. CREATE the appropriate _user_ ROLEs.
2: Create a GROUP (role that cannot login)  with the permissions needed.
3. GRANT that GROUP/ROLE to the user ROLEs that need it.  -> 
GRANT role_name [, ...] TO role_name [, ...] [ WITH ADMIN OPTION ]
https://www.postgresql.org/docs/current/static/sql-creategroup.html

https://www.postgresql.org/docs/current/static/sql-createrole.html

https://www.postgresql.org/docs/current/static/sql-grant.html
--
Melvin Davidson
Maj. Database & Exploration Specialist
Universe Exploration Command – UXC
Employment by invitation only!

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

Предыдущее
От: David Gauthier
Дата:
Сообщение: Can I grant permissions to specific set of uids (linux) ?
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: Can I grant permissions to specific set of uids (linux) ?