Re: Proposal: SET ROLE hook

From: Andres Freund <andres(at)anarazel(dot)de>
To: Joe Conway <mail(at)joeconway(dot)com>
Cc: PostgreSQL-development <pgsql-hackers(at)postgreSQL(dot)org>
Subject: Re: Proposal: SET ROLE hook
Date: 2015-10-16 16:28:16
Message-ID: 20151016162816.GM6851@awork2.anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Shay Rojansky 2015-10-16 17:00:05 Re: Allow ssl_renegotiation_limit in PG 9.5
Previous Message Joe Conway 2015-10-16 16:20:26 Proposal: SET ROLE hook