Postgres Pro
Downloads
Home   >   mailing lists

Re: Proposal: SET ROLE hook - Mailing list pgsql-hackers

From Joe Conway
Subject Re: Proposal: SET ROLE hook
Date
Msg-id 568E9B95.5070406@joeconway.com
Whole thread Raw
In response to Re: Proposal: SET ROLE hook  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Proposal: SET ROLE hook  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Re: Proposal: SET ROLE hook  (Joe Conway <mail@joeconway.com>)
List pgsql-hackers
Tree view 
On 01/06/2016 10:36 AM, Tom Lane wrote:
> I think a design that was actually somewhat robust would require two
> hooks, one at check_role and one at assign_role, wherein the first one
> would do any potentially-failing work and package all required info into
> a blob that could be passed through to the assign hook.

Fair enough -- will rework the patch and example code.

Thanks!

Joe

--
Crunchy Data - http://crunchydata.com
PostgreSQL Support for Secure Enterprises
Consulting, Training, & Open Source Development

pgsql-hackers by date:

Previous
From: Joe Conway
Date:
Subject: Re: Multi-tenancy with RLS
Next
From: Jarred Ward
Date:
Subject: Re: pglogical_output - a general purpose logical decoding output plugin