Postgres Pro
Downloads
Home   >   mailing lists

Re: Can I grant permissions to specific set of uids (linux) ? - Mailing list pgsql-general

From David G. Johnston
Subject Re: Can I grant permissions to specific set of uids (linux) ?
Date
Msg-id CAKFQuwZfPphBimfb+gWFTQkiuV8zLT8iE8QzxLwUxBU6igtoQw@mail.gmail.com
Whole thread Raw
In response to Can I grant permissions to specific set of uids (linux) ?  (David Gauthier <davegauthierpg@gmail.com>)
List pgsql-general
Tree view
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 by date:

Previous
From: Melvin Davidson
Date:
Subject: Re: Can I grant permissions to specific set of uids (linux) ?
Next
From: pinker
Date:
Subject: Re: dirty_ratio & dirty_background_ratio settings with huge memory