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 1lOPe4-0000BB-4Q for pgsql-hackers@arkaria.postgresql.org; Mon, 22 Mar 2021 18:51:20 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lOPe2-0007Bw-QU for pgsql-hackers@arkaria.postgresql.org; Mon, 22 Mar 2021 18:51:18 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lOPe2-0007Bo-8n for pgsql-hackers@lists.postgresql.org; Mon, 22 Mar 2021 18:51:18 +0000 Received: from mail-eopbgr700053.outbound.protection.outlook.com ([40.107.70.53] helo=NAM04-SN1-obe.outbound.protection.outlook.com) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lOPdx-0002Uu-7A for pgsql-hackers@postgresql.org; Mon, 22 Mar 2021 18:51:16 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=ZKJC2rq/m1sm2udNylVmP62sn1JYrJtIlYcSaOZrc5eIRyYHFmWrHRTEr/HOQqibnmwMPdIK4jhu7IoEhGgB6tP6e5VMKUOwI1CxNeWFh0BRXFQkLqv1uxhu5NRHs+HKV7gkSTBQ4NRRm4GaksIAgPOzOKFMpyk3aPvweA7yqQjQgR3ruSLJnY8+/Fwu1plSRPEA6Oqvn07kJNw2ap/Xi3WNVwuifm+Hl52S2giVFMErQN3jzVCFWP17alT0eQICzpD15J/YO4QMeXipJC0TJAciAB/3iQ+NJ9dmqQ8gHnUs2LHdl8AN8dlFqtBCg11IgRvUckhVGPXEbmyzd0CUYg== 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=AwjhrdwhEUXsPz3s57FsCK2GJkp8ManHUhc5v114HHI=; b=nSCmG7b62XAu18bb8VqFZ/UpIRx4hiIXVJyuJ8o/znFWDeWOj1NrByNePyODNdAVUFwVu818Q0xEFnR0M18iYkPlBTV1RGlJmndBcysUbMw682espcxqpb7HM4uibVQnXkSLHQVYdhq4mETPdg1/skAcSGTchZqibojvVXpbPxyOfRsVPf/1j8+6ApUrcm5dERPLrO9TI5oL0Uq8qZLMKpoUbdctEd+aWTIJRsXZsFW9CyciipFaC0zccQLrahjWL819Yer1/BMIKPB2HiEbK2SGTuYxF9/5gVAXX+ymVBG/ZtVadpF3EO3O9aX96HjS5Dk/T7k/4R1RJnO9Z3304w== 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=AwjhrdwhEUXsPz3s57FsCK2GJkp8ManHUhc5v114HHI=; b=z/6XAQT6zDgEO3gnOIQ4C6Xy95RoPHDF2EvgKwMvcjWIR8YgIo+NmWDipQ4GYekewmql8gpvnyxWZ3ngpYYVpjrO1bxVR1UhhEa99Nl6FQG8PE6peMIFphKXOilVO7O2GvoC7hXRC4VZF/fOs49EyLC2E6EmyyCkeXZmsTe+7S8= Received: from MWHPR05MB2896.namprd05.prod.outlook.com (2603:10b6:300:65::20) by CO1PR05MB7877.namprd05.prod.outlook.com (2603:10b6:303:d7::21) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.3977.9; Mon, 22 Mar 2021 18:51:10 +0000 Received: from MWHPR05MB2896.namprd05.prod.outlook.com ([fe80::4c6d:a666:643c:9244]) by MWHPR05MB2896.namprd05.prod.outlook.com ([fe80::4c6d:a666:643c:9244%8]) with mapi id 15.20.3977.018; Mon, 22 Mar 2021 18:51:10 +0000 From: Jacob Champion To: "magnus@hagander.net" , "michael@paquier.xyz" CC: "stark@mit.edu" , "pgsql-hackers@postgresql.org" , "sfrost@snowman.net" , "tgl@sss.pgh.pa.us" 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/fl6pFeJoAgAmCVACABIPmgIAXhdMAgAxttwCAA3O0AIABS40AgAAS9ACACTYWgIAEN3sAgAGUV4CAAI82AIAAHMKAgAPoFgCAALosAIAAGKqA Date: Mon, 22 Mar 2021 18:51:10 +0000 Message-ID: <3d9a91695d369d0ee14e8e9f126995578e623b79.camel@vmware.com> References: <4b2ca51542fa84e6fa37ab678624d5b400c092c0.camel@vmware.com> <679382aaff23627a2e53541322c7a3158d402394.camel@vmware.com> <65354d28ec024d610ee7fe0128a69075d2092043.camel@vmware.com> 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: f575633a-695c-4250-121d-08d8ed6375ab x-ms-traffictypediagnostic: CO1PR05MB7877: x-microsoft-antispam-prvs: x-ms-oob-tlc-oobclassifiers: OLM:7219; x-ms-exchange-senderadcheck: 1 x-microsoft-antispam: BCL:0; x-microsoft-antispam-message-info: JuQ+OYTRnsFIBg0lm1ZdwqgOXMWRd7n13AEdaWAVHiMU0ZPK65pYhRNZLGHo11uiEdM8t1h0F759BBEiI45M/qCDoPcymO4jNscxQFS3XPeBHe5YEE3KPu8XUUUBdm+HfHkVPeyXwWWoe4zgMj5h3Z/x8ONL/GoBWNeMBKt5CG5YUbZTY/sHZ2v3PTClOdZQz3PfXbGGW+8CCFPjk5sltf/AB5PP1hFD2I76q9dUFE6Nq7knnzAyMzw7UCPqTLJ8Lmxr9LHN2NihwNS8aZm+LcQXOGVmRTJz9VXMOkrla3YYV1tSJrGObPd/HkxfD7IYo5e7A5pBq3BSApIuTCeReymxf7jGTGbUa8bH3+pcWyTsHTsFObA52RSAvYb35H/aMDuhU3x1LZ4+2RCVm4giSIshcJYHzvHUVEBZbsODtGPuRiE2riY97FK9UVbRqo2zJfuNahT6OKgSOBtrCX51MF+/Taz/ZR5zPQ+AXhGfYkM9Vrduz3mRX57DMWLF/4LJv6G0QGXixYz8lTw1CI7tiGY2PbIO4dwkmXj2iMMZ2zEOg3D7KTqHdx1lYrF9q+qMlL950yqSrPFvJeLPKpmXqsFVG/b4T70VaKOG6bmqBmF9noDGGD8uqZatlMolefKndawI+SPJdnUC+xtuSTc1q7F6jJ+QWFlxQn7DEpKe7m58vhXPNmYB9MntftxRW5SM7v0nGV51ULQM6rlvjbF0lN7wwYhbH36Jur68SKjCqEae5ahiz1omuFob4QZJtVqh 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)(39860400002)(376002)(396003)(366004)(136003)(110136005)(6506007)(26005)(53546011)(4326008)(6486002)(478600001)(54906003)(71200400001)(86362001)(316002)(186003)(38100700001)(76116006)(6512007)(66556008)(66946007)(66476007)(83380400001)(64756008)(45080400002)(66446008)(2906002)(36756003)(8936002)(2616005)(5660300002)(8676002)(966005);DIR:OUT;SFP:1101; x-ms-exchange-antispam-messagedata: =?utf-8?B?c212Mjc0eitRNTAyU2hXZGQxZVJ0bDZEb3orZS9GczlUaXpscklabVR4Z00z?= =?utf-8?B?VVhEWldBSmR5UktpajlTM1g1ZWY3dHBMc1I3TzVORjFlZCs0M01wbW1FdStT?= =?utf-8?B?OVdzSUc5WTl5ZmVwY3lyc3J6RE1kMWh3ZFM0YWNlSlBCdDQrYlZqV1VyeHZ4?= =?utf-8?B?dTZ4VnVsN2xBeWYyRllPOGpJZG1nME5PUWNmbjF2ZWNCZXcyLzlvUEtrRG85?= =?utf-8?B?V3k3UTdVR1VJNE9rRkdDK0hxdVJuUjMrWnFmZ2FSWmdxOVA2Wmp3SVNwcGxP?= =?utf-8?B?NzBYMG96dmNlL3NWalBEWWlKaUdpQktEdndaRkZud2xPcTY1NHhkdW1ub1Nz?= =?utf-8?B?ZVFIWTlyUk5lQXlwQm5BbWUvc0ZwcHZGQzNsbVZ0SC9ucDZ6VG53NU9tbW95?= =?utf-8?B?UWlmb3V0VTZDMVdFMFJWVTJrZE1XaUowQUZ2SlBkZ3Y2Qk5NaHlzUmM5TWh2?= =?utf-8?B?Smpabk5zQzhiNnJiaDgwSzBIUlowNlAvTWk2bUt3c1lMOEo3dkJvR01LeFJ5?= =?utf-8?B?dTF2Yk1PQ2ZNa0ttZkZ6eEpPWjJ4OXFwUGtlTDhWbTg1Mk1mamhhNktWVkdy?= =?utf-8?B?N2xYYnE4UkRESzhKQklKK1cvazI3aHBLb2huU0VqQk5CdUVraDRVUkFLWko3?= =?utf-8?B?VVZPaDZvbUU1aDJMWDVwekhqbTg2ZXRGWlFaVkllOXNFckt1blhyT3Erd2ho?= =?utf-8?B?UkhMalVOL2pjZTdRdmc2VDhtWHk1VFU3UkVxbDRTcjBVNnNWTGt6MFRBOU1L?= =?utf-8?B?eGMrTkNDeEtkVkhsQ2VydVhsV0FFdDFEOXExVEhtYkF3THdjVUZIL3dtTTAw?= =?utf-8?B?dXl1SVpRNFdRcW5oTEJVaTRjbit1bFVUUXRXbFZWWXIzVm1YbzlHeHF6RkM4?= =?utf-8?B?dVg5MVdVc29LdmVaSVBUUEtRbFhXbGVkZDcyZnlUNWk2aktBcHZaNUs4cmlw?= =?utf-8?B?TU1uMU9hZ0NkMHZPK2xhWUZVekhFR0phNXVGeXZ3a3lJcXJYcU5Nck54ckNM?= =?utf-8?B?c0V4SndqMFZ6Y3pnTlF1WmZETFMvVDZEYk1ndG5JaWtOalBiTUhVa2tIVjBy?= =?utf-8?B?Z2lUaWdvR2l4SmwvMWhObGFsTDVkS0V3TlRXb3VJczRXNjhiUUZIZ1QyVm91?= =?utf-8?B?UnppWjhJMzVDTmR0bTVDb0kxaGQ0dGNLSVQwMHdBNDRPYlh1elRhQUNPdkkr?= =?utf-8?B?b3hkU2tab0VkdTBlVHhSOGZXMlJqU1I4dVkvdzY5L3VIQlBPU0N1NHQ3aEZM?= =?utf-8?B?QVV0YXRPZHlEOVlDZllGTlUrMzNFMDdKblQrKzhwU3ZUWGlyUUxYVlk0bUl4?= =?utf-8?B?T3YwYmE1eUh5YmFIWWVvb29Zdjg1V3pqWnVxV1FyYXJRcDZxY1ZmNjNWNEt5?= =?utf-8?B?VldJQzc2RXB4U0o1K2kxOGdmeVlpVEM2bmo0RDBQQmNHUUJMZWZEZCtSYmR6?= =?utf-8?B?YkppMmVIQ0xHS1A4NjZQdDdaK1ZKYkIxbVNKN2lESG44elBBVFNpcXNmTm5H?= =?utf-8?B?UFhNU204cVkyaUw0bW1vU1BzM1MxZ1JRc0hOa2djREpMYjk0Uk9WNVNyME5E?= =?utf-8?B?VVJJZ2p0Z09QYXZZa2NRRnpVVWlTSlRkR1ZrWHp2TFM0c3FRMGkzU3Q0ampG?= =?utf-8?B?SU0xU0Rkb2phdHUxWnQwVlJ5OURaVjhsZXdRT3dJejN2VHRqRTkwY0JaMlNs?= =?utf-8?B?Q2tLTS9nNnRFQ2loMkhrVkRKeXRaNXU4Y25iY1kybStQNkk0ejdWcHQ4MUFJ?= =?utf-8?Q?jvtkrGZIG3SB/0TDAwIf51oB8g64d8qiVDndJot?= x-ms-exchange-transport-forked: True Content-Type: text/plain; charset="utf-8" Content-ID: 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: f575633a-695c-4250-121d-08d8ed6375ab X-MS-Exchange-CrossTenant-originalarrivaltime: 22 Mar 2021 18:51:10.3456 (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: YnMHX22xBZEiPmBHy3W5xoDVXE0FKi/Za4nO/ZWzpQJc2s8MYRO/AqTJcqx7QfsKjt6RLcLL4SKjdhJVaumXbQ== X-MS-Exchange-Transport-CrossTenantHeadersStamped: CO1PR05MB7877 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk T24gTW9uLCAyMDIxLTAzLTIyIGF0IDE4OjIyICswMTAwLCBNYWdudXMgSGFnYW5kZXIgd3JvdGU6 DQo+IE9uIE1vbiwgTWFyIDIyLCAyMDIxIGF0IDc6MTYgQU0gTWljaGFlbCBQYXF1aWVyIDxtaWNo YWVsQHBhcXVpZXIueHl6PiB3cm90ZToNCj4gPiANCj4gPiBJIGhhdmUgYnJpZWZseSBsb29rZWQg YXQgMDAwMiAoMDAwMSBpbiB0aGUgYXR0YWNoZWQgc2V0KSwgYW5kIGl0IHNlZW1zDQo+ID4gc2Fu ZSB0byBtZS4gIEkgc3RpbGwgbmVlZCB0byBsb29rIGF0IDAwMDMgKHdlbGwsIG5vdyAwMDAyKSBp biBkZXRhaWxzLA0KPiA+IHdoaWNoIGlzIHZlcnkgc2Vuc2libGUgYXMgb25lIG1pc3Rha2Ugd291 bGQgbGlrZWx5IGJlIGEgQ1ZFLWNsYXNzDQo+ID4gYnVnLg0KPiANCj4gVGhlIDAwMDIvMDAwMS93 aGF0ZXZlcml0aXNhZnRlcnRoZXJlYmFzZSBpcyB0cmFja2VkIG92ZXIgYXQNCj4gaHR0cHM6Ly9u YW0wNC5zYWZlbGlua3MucHJvdGVjdGlvbi5vdXRsb29rLmNvbS8/dXJsPWh0dHBzJTNBJTJGJTJG d3d3LnBvc3RncmVzcWwub3JnJTJGbWVzc2FnZS1pZCUyRmZsYXQlMkY5MmU3MDExMC05MjczLWQ5 M2MtNTkxMy0wYmNjYjY1NjI3NDAlNDBkdW5zbGFuZS5uZXQmYW1wO2RhdGE9MDQlN0MwMSU3Q3Bj aGFtcGlvbiU0MHZtd2FyZS5jb20lN0NkMDg1YzFlNTZmZjA0NWM3YWYzMzA4ZDhlZDU3Mjc5YSU3 Q2IzOTEzOGNhM2NlZTRiNGFhNGQ2Y2Q4M2Q5ZGQ2MmYwJTdDMCU3QzAlN0M2Mzc1MjAzMDU4Nzg0 MTU0MjIlN0NVbmtub3duJTdDVFdGcGJHWnNiM2Q4ZXlKV0lqb2lNQzR3TGpBd01EQWlMQ0pRSWpv aVYybHVNeklpTENKQlRpSTZJazFoYVd3aUxDSlhWQ0k2TW4wJTNEJTdDMTAwMCZhbXA7c2RhdGE9 a3lXOU8xakQwejE0ejByQyUyQllZOVVoSUtiN0Q2YmcwbkNXb1ZCSmtGOG9RJTNEJmFtcDtyZXNl cnZlZD0wDQo+IGlzbid0IGl0PyBJJ3ZlIGFzc3VtZWQgdGhlIGV4cGVjdGF0aW9uIGlzIHRvIGhh dmUgdGhhdCBvbmUgY29tbWl0dGVkDQo+IGZyb20gdGhhdCB0aHJlYWQsIGFuZCB0aGVuIHJlYmFz ZSB1c2luZyB0aGF0Lg0KDQpJIHRoaW5rIHRoZSBwcmltYXJ5IHRoaW5nIHRoYXQgbmVlZHMgdG8g YmUgZ3JlZW5saXQgZm9yIGJvdGggaXMgdGhlDQppZGVhIG9mIHVzaW5nIHRoZSBSRkMgMjI1My80 NTE0IGZvcm1hdCBmb3IgU3ViamVjdCBETnMuDQoNCk90aGVyIHRoYW4gdGhhdCwgdGhlIHZlcnNp b24gaGVyZSBzaG91bGQgb25seSBjb250YWluIHRoZSBjaGFuZ2VzDQpuZWNlc3NhcnkgZm9yIGJv dGggZmVhdHVyZXMgKHRoYXQgaXMsIHBvcnQtPnBlZXJfZG4pLCBzbyB0aGVyZSdzIG5vDQpoYXJk IGRlcGVuZGVuY3kgYmV0d2VlbiB0aGUgdHdvLiBJdCdzIGp1c3Qgb24gbWUgdG8gbWFrZSBzdXJl IG15DQp2ZXJzaW9uIGlzIHVwLXRvLWRhdGUuIFdoaWNoIEkgYmVsaWV2ZSBpdCBpcywgYXMgb2Yg dG9kYXkuDQoNCi0tSmFjb2INCg==