Re: SET ROLE x NO RESET - Mailing list pgsql-hackers

From Joe Conway
Subject Re: SET ROLE x NO RESET
Date
Msg-id f261000a-f18d-40fd-aeee-0f5d548b4332@joeconway.com
Whole thread Raw
In response to Re: SET ROLE x NO RESET  (Michał Kłeczek <michal@kleczek.org>)
Responses Re: SET ROLE x NO RESET
List pgsql-hackers
On 12/30/23 17:19, Michał Kłeczek wrote:
> 
>> On 30 Dec 2023, at 17:16, Eric Hanson <eric@aquameta.com> wrote:
>>
>> What do you think of adding a NO RESET option to the SET ROLE command?
> 
> What I proposed some time ago is SET ROLE … GUARDED BY ‘password’, so 
> that you could later: RESET ROLE WITH ‘password'

I like that too, but see it as a separate feature. FWIW that is also 
supported by the set_user extension referenced elsewhere on this thread.

-- 
Joe Conway
PostgreSQL Contributors Team
RDS Open Source Databases
Amazon Web Services: https://aws.amazon.com




pgsql-hackers by date:

Previous
From: Joe Conway
Date:
Subject: Re: Build versionless .so for Android
Next
From: vignesh C
Date:
Subject: Re: Commitfest 2024-01 starting in 3 days!