On Tue, Mar 6, 2018 at 3:26 PM, David Gauthier <davegauthie...@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-creategroup.html>https://www.postgresql.org/docs/current/static/sql-createrole.html <https://www.postgresql.org/docs/current/static/sql-createrole.html>https://www.postgresql.org/docs/current/static/sql-grant.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!