| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | Ravi Krishna <sravikrishna(at)aol(dot)com> |
| Cc: | David Gauthier <davegauthierpg(at)gmail(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Can Pg somehow recognize/honor linux groups to control user access ? |
| Date: | 2018-08-22 16:44:39 |
| Message-ID: | CAKFQuwac-vqqfFsbjpywfPq7DvJ3p_XwE-SSn_MQaBmooB23Vg@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, Aug 22, 2018 at 9:38 AM, Ravi Krishna <sravikrishna(at)aol(dot)com> wrote:
> I am not sure this is the same what I was thinking about. For example, in
> db2, connect privilege can be granted to a group and so is grant privilege
> as in
> GRANT SELECT ON TABLE SCHEMA.TABLE TO GROUP ABC;
> GRANT CONNECT ON DATABASE TO GROUP ABC
>
>
The "LOGIN" attribute for a Role is not inheritable and I do not imagine
changing it to be is something the project can consider.
Every login user must have their own role in the database. These roles are
separate from O/S users though "mappings" can be established between the
two in pg_hba.conf.
David J.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dimitri Maziuk | 2018-08-22 17:23:49 | Re: Can Pg somehow recognize/honor linux groups to control user access ? |
| Previous Message | Ravi Krishna | 2018-08-22 16:38:10 | Re: Can Pg somehow recognize/honor linux groups to control user access ? |