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

From Andres Freund
Subject Re: Proposal: SET ROLE hook
Date
Msg-id 20151016162816.GM6851@awork2.anarazel.de
Whole thread Raw
In response to Proposal: SET ROLE hook  (Joe Conway <mail@joeconway.com>)
Responses Re: Proposal: SET ROLE hook  (Joe Conway <mail@joeconway.com>)
List pgsql-hackers
On 2015-10-16 09:20:26 -0700, Joe Conway wrote:
> One of the problems with this is we would ideally like to know whenever
> joe escalates himself to postgres. Right now that is not really possible
> without doing untenable things such as logging every statement.

Alternatively you can just have a elevate_user() function that does the
logging and escalating? That seems like the same amount of code and it'd
work with released versions of postgres?

Sure, that has some disandvantages over your approach, but for the
presented use case with humans needing to escalate I don't see any.

Greetings,

Andres Freund



pgsql-hackers by date:

Previous
From: Joe Conway
Date:
Subject: Proposal: SET ROLE hook
Next
From: Shay Rojansky
Date:
Subject: Re: Allow ssl_renegotiation_limit in PG 9.5