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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-admin by date

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