Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1l6haI-0002ze-6j for pgsql-hackers@arkaria.postgresql.org; Mon, 01 Feb 2021 22:22:14 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1l6haH-000100-4x for pgsql-hackers@arkaria.postgresql.org; Mon, 01 Feb 2021 22:22:13 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1l6haG-0000zt-Sx for pgsql-hackers@lists.postgresql.org; Mon, 01 Feb 2021 22:22:12 +0000 Received: from mail-bn7nam10on2074.outbound.protection.outlook.com ([40.107.92.74] helo=NAM10-BN7-obe.outbound.protection.outlook.com) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1l6haE-00013E-09 for pgsql-hackers@postgresql.org; Mon, 01 Feb 2021 22:22:12 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=WOGa8OO4xbNHAqzfvSu3bhRnVKY4z8gyVh8MG5VWIvUzbqqARChD5Sxz97kJOdTl2ZPlh+NwdOvReSF2mAkm0/yxi3OxmRNmj1uwucCsE/UEn35r+rGnb9VOlWe+7W6fHbBJSRIVLWLzU53JybQLkyINtlbSqU0ykdMlmEwSyeZXayZwCusdIr6X9Eue5HKk0tShPdbuHjS4UOtnImUrIoe/Cz4ffzpDHnnvXwFaAWeIK9xvbLVKYUGPr0X0nkje0vOrLoL0l3uN83SEN0lFSVfVlfa2g/UVIEb7Bp7h/H27+3bAgdS89dwRTCD7DaikNhV9/T/jSbzyo+ZyVyf3qg== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=8iGvsLx/ap+qelqh4+P/RPqgIOgS1cs/TYH4fnuf7aM=; b=Ahn+x0bU1XNjQj75qMG1YBzryI4JPiCF9FGNO5mZ6csqE7fmvAIr5xQ6NeJ77B/CjkMQrKtsRRuCioNX3DPDITPZbs+P0NrjiQpVxorU11GDE0cuY9/b2gFICjZrlwNPB22USQG+wbeG/+vpLUKjrnGsYwEQL8hhL7WOs3in5gHarF6QXR5Ma2D4HiUHc+7vNNkn+P42zEWfmtsyRoFzTbvltS2QJ97y25ehEx5dx4QunRtss/GFxBeXe6e1s+38dm1d/BOBJkMPFQcONIcK9+olkLuGc8QoG53TRgXR7/YyZLAr3VVNZBOvNzzHY2KA3ViUBBrMTjlgzgJEt1xpkg== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=vmware.com; dmarc=pass action=none header.from=vmware.com; dkim=pass header.d=vmware.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=vmware.com; s=selector2; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=8iGvsLx/ap+qelqh4+P/RPqgIOgS1cs/TYH4fnuf7aM=; b=OtiYFeOHH8Ub3ccsbgxKcaUdiefdNYINbtsb7yd6jgS1RUeeaCTjEQWX4/DWx78hEeO9P64i0K3cXhdQFLtUVIp78YyxQjyuLzuJatmcg2QjaHaL3YBecU5WhP7YSDxIKaE3eLsUDr5Z3SvzVZDF09Ibgp/o3Wh050Hvx8kqyKg= Received: from (2603:10b6:300:65::20) by MWHPR05MB3389.namprd05.prod.outlook.com (2603:10b6:301:42::23) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.3825.8; Mon, 1 Feb 2021 22:22:06 +0000 Received: from MWHPR05MB2896.namprd05.prod.outlook.com ([fe80::408b:a41e:e514:6620]) by MWHPR05MB2896.namprd05.prod.outlook.com ([fe80::408b:a41e:e514:6620%9]) with mapi id 15.20.3825.017; Mon, 1 Feb 2021 22:22:06 +0000 From: Jacob Champion To: "magnus@hagander.net" , "tgl@sss.pgh.pa.us" CC: "stark@mit.edu" , "pgsql-hackers@postgresql.org" , "sfrost@snowman.net" Subject: Re: Proposal: Save user's original authenticated identity for logging Thread-Topic: Proposal: Save user's original authenticated identity for logging Thread-Index: AQHW9aJ84UHIxxQGM0uvKhvSVw/fl6o/KTGAgAAISwCAABFqAIAAAhsAgAKYH4CAAAoHAIABpqGAgAAHSICAAANlAIAATZ2A Date: Mon, 1 Feb 2021 22:22:05 +0000 Message-ID: <305adafb1e41608f0c4b30bf01a83205c5f27809.camel@vmware.com> References: <20210129220101.GE27507@tamriel.snowman.net> <2829030.1611959442@sss.pgh.pa.us> <2832058.1611963634@sss.pgh.pa.us> <3085246.1612108406@sss.pgh.pa.us> <20210201170605.GJ27507@tamriel.snowman.net> <3344750.1612200729@sss.pgh.pa.us> In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: user-agent: Evolution 3.36.4-0ubuntu1 authentication-results: hagander.net; dkim=none (message not signed) header.d=none;hagander.net; dmarc=none action=none header.from=vmware.com; x-originating-ip: [50.39.198.229] x-ms-publictraffictype: Email x-ms-office365-filtering-correlation-id: dbc1539e-53b5-4e8c-d80f-08d8c6ffcecb x-ms-traffictypediagnostic: MWHPR05MB3389: x-microsoft-antispam-prvs: x-ms-oob-tlc-oobclassifiers: OLM:10000; x-ms-exchange-senderadcheck: 1 x-microsoft-antispam: BCL:0; x-microsoft-antispam-message-info: 871HVoUnjpDoI2CsMCeSaCC8c7TK8SKPZWW+2UytVQHle9TNZ+qxV2GIEUAFiN1aTb6pwPfz0T2c02BdUCdADwAeA6y48SfL/urQL63r7Mfl0aQtlDsYkX37QmJoSf08P9ne/PWXWsTJfxq+2nqE/DNYiXuPEvnf+h8RTg9Vcw86Ne2ayGuEjZQ1p2ryPtrhT/pX1PL5QzyR+ZW1L+pW4YVAULaULzABe2bsbeB4U3bBd5w6zGBDc0uBXzIoqyT6ck1uWERoKCwDe/GsI43YYroDVL9ZEFEawSorYV5qES0XxRsA8cowoGq7QOHRBkS1J9oUcCMAioqylEh3IgBQVm9U2uSAlLkbQ8OiWUrq4IM/Z4oGKlYP5R4nYZTWJyHXDpN0jDLimQIXv2lYL+qVa2aWj8es3r+Aggf8fJIAleMa02KRVNw2BB0Xxd8+Qtj/jmrkKHYDPFCWtojPiJrznvKb8R1Iiegeacyi1Y8OvZbyJmk9nw9nu01MeBs7orirNNbRzneI0VzL27rTQhkmEQ== x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:MWHPR05MB2896.namprd05.prod.outlook.com;PTR:;CAT:NONE;SFS:(4636009)(346002)(136003)(376002)(396003)(366004)(39860400002)(8936002)(83380400001)(6512007)(6486002)(110136005)(36756003)(316002)(2906002)(2616005)(76116006)(86362001)(4326008)(6506007)(66446008)(26005)(186003)(66476007)(8676002)(478600001)(64756008)(66946007)(5660300002)(71200400001)(54906003)(66556008);DIR:OUT;SFP:1101; x-ms-exchange-antispam-messagedata: =?utf-8?B?Y242Qnp0SWhEODQ2OFRFeUhvOXlEdS9CQnBUMGs4N1l4NlRYTUhOcWpMdnZI?= =?utf-8?B?VHpob0dTeElUQ2Y2aXVuTHdTUnhqTVVPWmppRTh2NTZwSk5FSW8zZ2hIZWtP?= =?utf-8?B?ZDJ0QXRJdk1sNXcrbXFyOWd3VThUMkZ4Qm1CRFlGZWtGbHNXMC9vWEZOTk1K?= =?utf-8?B?ZnBoa2tMVWRydlNidWg4TGtsRGNPVjFGTlBNTlI2ZUY5bjR5eEliSjdleW5P?= =?utf-8?B?cFUzQ0FlblVRcnVBSldlSE9vSDkyNTdEbDRQVVcxWDdFZkNHQ3FuRDhVODBU?= =?utf-8?B?NXpnOExWNDhsVHM1WlRaUU5CdmJvNDB6TElqd0J5TTUzNmNQcG9VdUR5MDZJ?= =?utf-8?B?SjFWdkcrSEtIb09jbW5ITXFPUkc2KzdtSGRyRFhZQS8xaEJLZWpXMEtCdHht?= =?utf-8?B?Tk9YYlRXeit1L3o5WFkrdjRuZ3RZaElSTGhrSTNPNzdrMFk4UldEb2NydXlx?= =?utf-8?B?QkplcFVMci9sb09Ld0FaR2Q4ZHV4V01mZGNVNk9uYlJMUjFscEJsWnFOd0Nj?= =?utf-8?B?QmtVRG5BTFZ4QythTXAvU0xBYzBuWDR3eks1cVJFQUZ4VVdxMUhJNDhrb1VY?= =?utf-8?B?aFhzdk5sbEJ2N0xXSDQzc2FWeVdIY044eGFEQjlBSlJXTEgvTCtxZ2FEV240?= =?utf-8?B?amdjYVNJYmJjYW9FUitlK1AwZ21PL3Z6YUVQWDdTQjBNR3ZRbGh0T2Q5SnN2?= =?utf-8?B?T3Evb3JnWHJnOUxoRGMwTFBTY0I2SDNEc0RpdXgrV1F2YXhhQzJUWkhwNERw?= =?utf-8?B?MUtSdjNGaGlwU0lJRUlZMXcwWHc0RzFlVzhXcWllVW5CSHhxdXVRa050QTM4?= =?utf-8?B?MDFJWTBKMmhzbk9SZUc4MWtpMmdFZkVpUUNMYktTSEg5OXBmSS95RnR0UWJF?= =?utf-8?B?Uk0xTS92MmNyejM5QXlnak1kNVpXOWd2V2VQUTdjMnJLbjM1NFZlc0laZWRT?= =?utf-8?B?WEU0M2svd0tHWlpvb3V4MHJZekxyN2NzWWtseFJGWHJBQ09qUW02T0dURDhh?= =?utf-8?B?Si9FTkR6Z1NmZ1BjeHBFMHZERTFCME1pUnJDaDNId1prUEpJbk5Fb1Jib3Fo?= =?utf-8?B?RUJPUFdGVmI0bTIyQURsMEp2RVUvT2VnSlpyUDhKY3h2aHM0RUtoQVBlbHhi?= =?utf-8?B?L3VCeEozQWYwbXA3dEFEWUhTVTcvbXJQMS8zdjZlUUdiU3hXa1hIcCtBdjBV?= =?utf-8?B?SFZXTlh6bENoSVA4Q1dWd3BERDI1TVRWanp1SjBmeG91NG1OeXdTeSsvREhI?= =?utf-8?B?NjRsWkpFbHpaWGVuSXUwYVp1UVNCd2pkallzU1owaVlpY05rc2g5REVpbTBC?= =?utf-8?B?NTVoOFBTazV1TmJ5L25wYS9GbTk1d1VpdWhvWndiS2JSU1h3amFQYkFMNXNh?= =?utf-8?B?bU9VYUhvNlVYM3k4RFJEaUxKQ3QxU0xsNkVPbVVCQmtDRVM4aWsrMmIzK2tC?= =?utf-8?B?ZnY4SGthcFRmSHNCejhmQnhlbjkyaWlLUTQ5Mmd3PT0=?= x-ms-exchange-transport-forked: True Content-Type: text/plain; charset="utf-8" Content-ID: <213B82B89E40984295B6222714672BA7@namprd05.prod.outlook.com> Content-Transfer-Encoding: base64 MIME-Version: 1.0 X-OriginatorOrg: vmware.com X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: MWHPR05MB2896.namprd05.prod.outlook.com X-MS-Exchange-CrossTenant-Network-Message-Id: dbc1539e-53b5-4e8c-d80f-08d8c6ffcecb X-MS-Exchange-CrossTenant-originalarrivaltime: 01 Feb 2021 22:22:05.9791 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: b39138ca-3cee-4b4a-a4d6-cd83d9dd62f0 X-MS-Exchange-CrossTenant-mailboxtype: HOSTED X-MS-Exchange-CrossTenant-userprincipalname: bg9pxaUd98d+4QzFc0ghwvl1gSY/8KvHmL2fPqrM3JPr3ZjLOf/ookPzqvYkpImjUTk9Ry5ilRzQXisYexwBNQ== X-MS-Exchange-Transport-CrossTenantHeadersStamped: MWHPR05MB3389 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk T24gTW9uLCAyMDIxLTAyLTAxIGF0IDE4OjQ0ICswMTAwLCBNYWdudXMgSGFnYW5kZXIgd3JvdGU6 DQo+IFdoYXQgcGVvcGxlIHdvdWxkICpyZWFsbHkqIHdhbnQgSSB0aGluayBpcyAiYWxvdyBhdXRv LWNyZWF0aW9uIG9mIG5ldw0KPiByb2xlcywgYW5kIHRoZW4gbG9vayB1cCB3aGljaCBvdGhlciBy b2xlcyB0aGV5IHNob3VsZCBiZSBtZW1iZXJzIG9mDQo+IHVzaW5nIGxkYXAiIChvciAidXNpbmcg dGhpcyBzY3JpcHQgb3ZlciBoZXJlIiBmb3IgYSBtb3JlIGZsZXhpYmxlDQo+IGFwcHJvYWNoKS4g V2hpY2ggaXMgb2YgY291cnNlIGEgd2hvbGUgZGlmZmVyZW50IHRoaW5nIHRvIGRvIGluIHRoZQ0K PiBwcm9jZXNzIG9mIGF1dGhlbnRpY2F0aW9uLg0KDQpZZXAuIEkgdGhpbmsgdGhlcmUgYXJlIGF0 IGxlYXN0IHRocmVlIHNlcGFyYXRlIHRoaW5nczoNCg0KMSkgdGhpcmQtcGFydHkgYXV0aGVudGlj YXRpb24gKCJ0ZWxsIG1lIHdobyB0aGlzIHVzZXIgaXMiKSwgd2hpY2ggSQ0KdGhpbmsgUG9zdGdy ZXMgY3VycmVudGx5IGhhcyBhIGZhaXJseSBnb29kIGhhbmRsZSBvbjsNCg0KMikgdGhpcmQtcGFy dHkgYXV0aG9yaXphdGlvbiAoInRlbGwgbWUgd2hhdCByb2xlcyB0aGlzIHVzZXIgY2FuDQphc3N1 bWUiKSwgd2hpY2ggUG9zdGdyZXMgZG9lc24ndCBkbywgdW5sZXNzIHlvdSBoYXZlIGEgc2NyaXB0 DQphdXRvbWF0aWNhbGx5IHVwZGF0ZSBwZ19pZGVudCAtLSBhbmQgZXZlbiB0aGVuIHlvdSBjYW4n dCBkbyBpdCBmb3INCmV2ZXJ5IGF1dGhlbnRpY2F0aW9uIHR5cGU7IGFuZA0KDQozKSB0aGlyZC1w YXJ0eSByb2xlIGFkbWluaXN0cmF0aW9uICgidGVsbCBtZSB3aGF0IHJvbGVzIHNob3VsZCBleGlz dCBpbg0KdGhlIGRhdGFiYXNlLCBhbmQgd2hhdCBwZXJtaXNzaW9ucyB0aGV5IGhhdmUiKSwgd2hp Y2ggY3VycmVudGx5IGV4aXN0cw0KaW4gYSBsaW1pdGVkIGhhbmRmdWwgb2YgdGhpcmQtcGFydHkg dG9vbHMuDQoNCk1hbnkgdXNlcnMgd2lsbCB3YW50IGFsbCB0aHJlZSBvZiB0aGVzZSBxdWVzdGlv bnMgdG8gYmUgYW5zd2VyZWQgYnkgdGhlDQpzYW1lIHN5c3RlbSwgd2hpY2ggaXMgZmluZSwgYnV0 IGZvciBtb3JlIGFkdmFuY2VkIHVzZSBjYXNlcyBJIHRoaW5rDQppdCdkIGJlIHJlYWxseSB1c2Vm dWwgaWYgeW91IGNvdWxkIGFuc3dlciB0aGVtIGZ1bGx5IGluZGVwZW5kZW50bHkuDQoNCkZvciBy ZWFsbHkgZ2lnYW50aWMgZGVwbG95bWVudHMsIHRoZSBvdmVyaGVhZCBvZiBodW5kcmVkcyBvZiBQ b3N0Z3Jlcw0KaW5zdGFuY2VzIHJhbmRvbWx5IHBpbmdpbmcgYSBjZW50cmFsIHNlcnZlciBqdXN0 IHRvIHNlZSBpZiB0aGVyZSBoYXZlDQpiZWVuIGFueSBuZXcgdXNlcnMgY2FuIGJlIGEgY29uY2Vy bi4gSGF2aW5nIGEgc29saWQgc3lzdGVtIGZvcg0KYXV0aG9yaXphdGlvbiBjb3VsZCBwb3RlbnRp YWxseSBkZWNyZWFzZSB0aGUgbmVlZCBmb3IgYSByb2xlIGF1dG8tDQpjcmVhdGlvbiBzeXN0ZW0s IGFuZCByZWR1Y2UgdGhlIG51bWJlciBvZiBtb3ZpbmcgcGFydHMuIElmIHlvdSBoYXZlIGENCnNt YWxsIG51bWJlciBvZiBjb3JlIHJvbGVzIChyZWxhdGl2ZSB0byB0aGUgbnVtYmVyIG9mIHVzZXJz KSwgaXQgbWlnaHQNCm5vdCBiZSBhcyBpbXBvcnRhbnQgdG8gY29uc3RhbnRseSBrZWVwIHJvbGUg bGlzdHMgdXAgdG8gZGF0ZSwgc28gbG9uZw0KYXMgdGhlIGNlbnRyYWwgYXV0aG9yaXR5IGNhbiB0 ZWxsIHlvdSB3aGljaCBvZiB5b3VyIGV4aXN0aW5nIHJvbGVzIGENCnVzZXIgaXMgYXV0aG9yaXpl ZCB0byBiZWNvbWUuDQoNCj4gVGhlIG1haW4gdGhpbmcgeW91J2QgZ2FpbiBieSBhdXRvLWNyZWF0 aW5nIHVzZXJzIHJhdGhlciB0aGFuIGp1c3QNCj4gbGV0dGluZyB0aGVtIGxvZyBpbiBpcyB0aGUg YWJpbGl0eSB0byBrbm93IGV4YWN0bHkgd2hpY2ggdXNlciBkaWQNCj4gc29tZXRoaW5nLCBhbmQg dmlldyB3aG8gaXQgcmVhbGx5IGlzIHRocm91Z2ggcGdfc3RhdF9hY3Rpdml0eS4gQWRkaW5nDQo+ IHRoZSAib3JpZ2luYWwgYXV0aCBpZCIgYXMgYSBmaWVsZCBvciBhdmFpbGFibGUgbWV0aG9kIHdv dWxkIHByb3ZpZGUNCj4gdGhhdCBpbmZvcm1hdGlvbiBpbiB0aGUgbWFwcGVkIHVzZXIgY2FzZSAt LSBtYWtpbmcgdGhlIGRpZmZlcmVuY2UgZXZlbg0KPiBzbWFsbGVyLiBJdCdzIHJlYWxseSB0aGUg YXV0by1tZW1iZXJzaGlwIHRoYXQncyB0aGUga2lsbGVyIGZlYXR1cmUgb2YNCj4gdGhhdCBvbmUs IEkgdGhpbmsuDQoNCkFncmVlZC4gQXMgbG9uZyBhcyBpdCdzIHBvc3NpYmxlIGZvciBtdWx0aXBs ZSB1c2VyIGlkZW50aXRpZXMgdG8gYXNzdW1lDQp0aGUgc2FtZSByb2xlLCBzdG9yaW5nIHRoZSBv cmlnaW5hbCBhdXRoZW50aWNhdGVkIGlkZW50aXR5IGlzIHN0aWxsDQppbXBvcnRhbnQsIHJlZ2Fy ZGxlc3Mgb2YgaG93IHlvdSBhZG1pbmlzdGVyIHRoZSByb2xlcyB0aGVtc2VsdmVzLg0KDQotLUph Y29iDQo=