Skip site navigation (1) Skip section navigation (2)

Grant Privliages Based on Unix Groups

From: "Klink, John" <john(dot)klink(at)hp(dot)com>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Grant Privliages Based on Unix Groups
Date: 2012-07-31 23:00:42
Message-ID: B5B11DCD0EA365428BF4C0CAB7FBE69CBA2868@G9W0764.americas.hpqcorp.net (view raw or flat)
Thread:
Lists: pgsql-admin
I am trying to setup readonly access to my user groups.  I would like to grant select on a set of tables based on what Unix group they belong to.  This way when new users are added to a ronly group on the ldap server, I don't have to go to each data base to update a local group on each postgres data base.

I realize you can create a groups and users in postgres and add users to groups.  I would like for postgres to grant or deny access based on the users Group ID on the system vs having to create and manage groups on each of my postgres data base servers.

Current version running is:

psql (PostgreSQL) 8.4.4
contains support for command-line editing

I have been searching but can't find a reference to using unix groups to grant select, only references to groups created in postgres.

Thanks in advance.

John

pgsql-admin by date

Next:From: Gary WebsterDate: 2012-08-01 15:43:24
Subject: [pgsql] How bad is this full vacuum error?
Previous:From: Craig JamesDate: 2012-07-30 16:52:39
Subject: Re: Sometime Update is not modifying data inside database.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group