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 1lJOB2-0000FC-9R for pgsql-hackers@arkaria.postgresql.org; Mon, 08 Mar 2021 22:16:36 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lJOB1-0007lJ-7f for pgsql-hackers@arkaria.postgresql.org; Mon, 08 Mar 2021 22:16:35 +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 1lJOB0-0007lC-Gj for pgsql-hackers@lists.postgresql.org; Mon, 08 Mar 2021 22:16:34 +0000 Received: from mail-dm6nam12on2043.outbound.protection.outlook.com ([40.107.243.43] helo=NAM12-DM6-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 1lJOAs-0001VT-DG for pgsql-hackers@postgresql.org; Mon, 08 Mar 2021 22:16:32 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=VQqS7+S6k0OCHBQ5YLC5fRnmcu/HgeKdcN+7dxWEQRESFyLyXBnU1aZJg2Cxq8Im+6kyR3UorpJQu0c9MhbYjz2guLUzkTEOH87lTSZJouSE12NIfA8s6bID1x4SZXqfOXuY0hTGZBT0APxIn4DtKs8xvHY5l1s24AeBNcbtBGSTHDyM9l2GxUI2SDk1SRHOq2jArVZqhQenc0MmymkGb2Hh+q7cZY7dp7rMHRG6ysq4Cdl4mgzfZ5LMlr+Exf98W+9kjXyeFIKnGAobYkVTsqSS/fJhn438MkLVax25o4bsT1ZpTFBcmLkwt2Kpu4ROxINzPM8Vfy680VgogK+aXw== 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=itpLC7e9Zr/L4ScvKz3skyp1fCgHKAfutoThPyG4Tmo=; b=dtUNzgNBkVQpDLPYgPk8xStAX8cC2xSjhcBCJ2cwBVfFyzikY5F25fNaQ/JYIRS8zHsGVm80g+CSvHhj52vWzm4eQYIDuxRXGo1XVBe1boJqGZGQoXXl4M2BoCpwz1lKz+jc6Iu9dPCwbm8PetChLeMZsKAAadLxRQVIKMYyYxMQlKvkDiwa/EytC4yyptYihB4FlWpwZoKUshgsSEBW9J0mGuHkZpcLzX+cT2lJ79Km9oUoLhDWF/CoRPldc8PLhtoKHgB65ujQ/uMqqZRXoe4SCC/9pGK9KN06pWySRmYL2n9LHVHdgW/FnOS5xQsHKcFWyB9bY6c1I47Z5MA8Ew== 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=itpLC7e9Zr/L4ScvKz3skyp1fCgHKAfutoThPyG4Tmo=; b=cgefevGA3CZj9kFu7Oe+RU9Ch+ei5XphisYd0a2dHUNlBH4QzfDEWXZDer4gAMCzGxzGH79Bh6tDnsOBdeYBjEsL9od68yJoAZoRuWGj05/MPz5YP85mGf8zlMVenOHUbTp1LIdQSK2BiwouAhIyd5yLysIwsvwtRjchPrU04KI= Received: from MWHPR05MB2896.namprd05.prod.outlook.com (2603:10b6:300:65::20) by CO2PR05MB2662.namprd05.prod.outlook.com (2603:10b6:102:f::14) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.3912.9; Mon, 8 Mar 2021 22:16:23 +0000 Received: from MWHPR05MB2896.namprd05.prod.outlook.com ([fe80::cc46:e1a9:6424:c456]) by MWHPR05MB2896.namprd05.prod.outlook.com ([fe80::cc46:e1a9:6424:c456%12]) with mapi id 15.20.3933.025; Mon, 8 Mar 2021 22:16:23 +0000 From: Jacob Champion To: "magnus@hagander.net" 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/fl6pFeJoAgAmCVACABIPmgIAXhdMAgAxttwCAA3O0AA== Date: Mon, 8 Mar 2021 22:16:23 +0000 Message-ID: References: <5d8b74e64fe4a610b23624277e497cc0a925db4b.camel@vmware.com> <2870147caa759155c5c8a232bbd2399f41f76491.camel@vmware.com> <4b2ca51542fa84e6fa37ab678624d5b400c092c0.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: 823d7e0b-16a5-43a2-3045-08d8e27fcf2a x-ms-traffictypediagnostic: CO2PR05MB2662: x-microsoft-antispam-prvs: x-ms-oob-tlc-oobclassifiers: OLM:9508; x-ms-exchange-senderadcheck: 1 x-microsoft-antispam: BCL:0; x-microsoft-antispam-message-info: y8SZbRojWiZLQi4o+8VLBu5o6SacF/3MIXRXxuzGCK2dUX8VP3IKNE9616djCm32lmS5XgpBT4LpvJYrUrju5ub3KQQt3l5cq4mVbw/TMs95FNZxYsSheztU7h4a+3VEx7esZfS9GsrFwFRHEwkTbqjuc6ge0aTU1rvW+wRW5B+2PYsevTbWEujSQtsq/DS718yL+76PyifNPsHzFLofdf2+Ux9KCozyBCOp4LoGbE0W5P4ivYzF8fMjescE3c3+vBXOol0F5nc7qumM1wV+YOXraVJ3ll3pvKAv/V9xKmU95Y43bR2KAuwhtfeCAh81SDWjGBC/4PfH/TrPFedBldsAte4INeXhI0jWEwkcLLYuSFcmqnvb72E5AXpCqI0zltt1UzIduyv8A/GwQxmQWcMsDQDXF3WbYP8+YyVpvi3sa23Ldh5QKqeMxIGDKiTu28m4e78IGNw3pCXcjqKvjdzR5k55hOCIIaHo2NXGys/LhIiYdLHubkCBeOnLDDe6vA/UMWl+K3YS7vCwPz/GAg== 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)(136003)(39860400002)(396003)(346002)(376002)(366004)(2906002)(5660300002)(6506007)(36756003)(71200400001)(66946007)(6916009)(26005)(54906003)(2616005)(186003)(4326008)(316002)(8936002)(64756008)(76116006)(66476007)(83380400001)(6512007)(66556008)(8676002)(66446008)(86362001)(6486002)(478600001);DIR:OUT;SFP:1101; x-ms-exchange-antispam-messagedata: =?utf-8?B?cEJ6SGhKMTc5KzNBTlpkcVh4SGFGSGtKcXJRaktKWTdSU2xTb0ZZd3FMUlF4?= =?utf-8?B?ZUhjTGFUN1pKSHpBNmpIOXVRdGFqNDZjbk4xWFFabkdVNHAzSlg3ajNuZHpv?= =?utf-8?B?NTFRSkVQRDVvaFI3bjBad0tUdHlyUm91ZzAzMDZOZ3VvS1RsNCtvdzROZTVm?= =?utf-8?B?cXNNNzlOdm8xM0ZaenB5R3BRTXpPMlJiZkd1OVRPeEEvb04yTStieUZVd3JL?= =?utf-8?B?aVVZaWY4S1lhZ0l3ai9YeCtXU0dzUnlzNEdxc0VYdHV0S2FUaE9tZE5OSUhp?= =?utf-8?B?Q3pTd2Z6ZVJJQjRFbnphQXVPN3FpVmUwa2EvRHAyVWRyUFhwYy9LRHRrYWNT?= =?utf-8?B?WEhTa2JjOElITlBzTXhtVW1QRnREMmk3cFNTYXJNMjlQZ21ESjdNVk1UVjFK?= =?utf-8?B?YzVGMm1BaG40allQZmlEbERRZG5GMFJGYjZOeTcxamFabmhaekF5aEhPajNl?= =?utf-8?B?NzJqQlBiSVJwUDJ5T0kvY3pPV3ZDSVZRaHJadXJNdkxhZzNCQzJKMkdsTU1q?= =?utf-8?B?cGxtZWdJVS9OcXc5bmYwKzFURjQzTTJSL0xLR0FOM3FVQWp4RFBtTFE4K2VU?= =?utf-8?B?UVJ6VVBTV0Z4NjFHMlU1cEtSWmljQTVydnpJNTQzcXkwdlZUcjVYSHRSQmx1?= =?utf-8?B?djQ3RnBZRFRrQS9VY29Ic1o0M3I4SXVTQ3NtTUp6RUc3L3hrc0tacTF5eERX?= =?utf-8?B?aUhuVmdXbzI5TmV0NklDTEJtRUdjQURmZ2NhT2hhVk1pV1FubTJWaXZuOUhz?= =?utf-8?B?ZnNWZHRJNHRWWkpaZzhSWTlVaWtlV2NxVUUwMEZnZUdjV2FvVHg1UmU3QVlC?= =?utf-8?B?K0w1WGNqd0hTTjRUOHNKZ3FQNmgveGNnRFBPcUJ5dVJmb2hpTnFQV3JhZWtG?= =?utf-8?B?Vy9OQ2FNdHlpNmNNQkZGRVlCSW9yM0tjR0VKQXl4MU1GMnl3MVlpUHNVeC9B?= =?utf-8?B?NTFMODVxYnNjTXIyMy9lcFNLR21QK05QZWlVWE1jdGl5bjVrSzNRb1RYelp2?= =?utf-8?B?MEJjelNmWUNxSnRLZWJFUVdxMThDZ1dUcTNPUWNvZld0TlpuMmRKWFZsdWdS?= =?utf-8?B?M0pVZlpOZW5KdlY2Z014NzM1Y1pmM3NZaGswWksveDdDWUpwVEhGRTR4VXB2?= =?utf-8?B?cndMNU5MQzFJcG81RWtFMjJ1Q2g0Z3FpTDZ4WjVkYUZsQndFWXBZeVlYZEhN?= =?utf-8?B?TmVIK3p2cUpLMEY3NElpd2tqaXpxbHd1NkNmVm5PYlZMMmQ0Z1hCMkcxWlBq?= =?utf-8?B?NkVzQW9sTUhDNStzVzh1Q3Z3bXZ5d2ZhQVV0eEordVcyUEZ0bUYrd2NFVFZ5?= =?utf-8?B?SG1YUFMvQTJxbXo5TzJyQStSYTFaZnlqN0RwRjBaWFE4aWNFTVNrTGJaaXJ1?= =?utf-8?B?d1ZYTmd1Uk1ldng1bGRmWTFTcDlwN1NZWDdSN2R0Y1hjMGp5ZDFWaHRHbXF4?= =?utf-8?B?aGJzSndOL2hrOVQrZ3FqOWFIei9pSnRadlQ4aG5ocGUyUk5HRno4a2drYmhP?= =?utf-8?B?Y251UjJmczhOaUtoekNsc0lPZEJvWGJhbkRTWkpIZDdMUnN1RXRxcUNhRnUx?= =?utf-8?B?bXBpOGZoYkw2a2UyVjZGVjlidG4wUFJzNnBHVFJvOW1OSnRZM3ZjaVpzdkE0?= =?utf-8?B?TmFmR2xUUi9jeXNheWJ2MTE3UFFyRmdCRjMyaDlVRU9MZ1lGM2wzRi9Eckk0?= =?utf-8?B?MWx6ZDFzd1FYM2dyOUt0RlBLei8yU3JROGxMbC9mcC9EWi9hcWdKZU5IcFd5?= =?utf-8?Q?UDCpdmCyRofNt4ZKK+GuvEjsnhIspQVgOJEh6HX?= x-ms-exchange-transport-forked: True Content-Type: text/plain; charset="utf-8" Content-ID: <1851D1FEB68AFF4587B7A5AB7E66D533@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: 823d7e0b-16a5-43a2-3045-08d8e27fcf2a X-MS-Exchange-CrossTenant-originalarrivaltime: 08 Mar 2021 22:16:23.6278 (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: Pzc2P+sqcOCScSTmD8W5ERFycoIGubU3fKrmscIBkqgOl1aMo90yqIrRzWaJHaJhIE7Uy+rsKaAaDBdLRaUmoA== X-MS-Exchange-Transport-CrossTenantHeadersStamped: CO2PR05MB2662 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk T24gU2F0LCAyMDIxLTAzLTA2IGF0IDE4OjMzICswMTAwLCBNYWdudXMgSGFnYW5kZXIgd3JvdGU6 DQo+IEl0IGxvb2tzIGxpa2UgcGF0Y2ggMDAwMSBoYXMgc29tZSBsZWZ0b3ZlciBkZWJ1Z2duaWcg Y29kZSBhdCB0aGUgZW5kPw0KPiBPciBkaWQgeW91IGludGVuZCBmb3IgdGhhdCB0byBiZSBpbmNs dWRlZCBwZXJtYW5lbnRseT8NCg0KSSdkIGludGVuZGVkIHRvIGtlZXAgaXQgLS0gaXQgd29ya3Mg aGFuZC1pbi1oYW5kIHdpdGggdGhlIGV4aXN0aW5nDQoiY3VycmVudF9sb2dmaWxlcyIgbG9nIGxp bmUgb24gMjE5IGFuZCBtaWdodCBrZWVwIHNvbWVvbmUgZnJvbSB0ZWFyaW5nDQp0aGVpciBoYWly IG91dC4gQnV0IEkgY2FuIGNlcnRhaW5seSByZW1vdmUgaXQsIGlmIGl0J3MgY2x1dHRlcmluZyB1 cA0KdGhlIGxvZ3MgdG9vIG11Y2guDQoNCj4gQXMgZm9yIGxvZyBlc2NhcGluZywgd2UgcmVwb3J0 IHBvcnQtPnVzZXJfbmFtZSBhbHJlYWR5IHVuZXNjYXBlZCAtLQ0KPiBzdXJlbHkgdGhpcyBzaG91 bGRuJ3QgYmUgYSB3b3JzZSBjYXNlIHRoYW4gdGhhdD8NCg0KQWgsIHRoYXQncyBhIGZhaXIgcG9p bnQuIEknbGwgcmVtb3ZlIHRoZSBUT0RPLg0KDQo+IEkgd29uZGVyIGlmIGl0IHdvdWxkbid0IGJl IGJldHRlciB0byBrZWVwIHRoZSBsb2cgbGluZSBvbiB0aGUgZXhpc3RpbmcNCj4gImNvbm5lY3Rp b24gYXV0aG9yaXplZCIgbGluZSwganVzdCBhcyBhIHNlcGFyYXRlIGZpZWxkLiBJJ20ga2luZCBv Zg0KPiBzcGxpdCBvbiBpdCB0aG91Z2gsIGJlY2F1c2UgSSBndWVzcyBpdCBtaWdodCBtYWtlIHRo YXQgbGluZSB2ZXJ5IGxvbmcuDQo+IEJ1dCBpdCdzIGFsc28gYSBsb3QgbW9yZSBjb252ZW5pZW50 IHRvIHBhcnNlIGl0IG9uIGEgc2luZ2xlIGxpbmUgdGhhbg0KPiBhY3Jvc3MgbXVsdGlwbGUgbGlu ZXMgcG90ZW50aWFsbHkgb3ZlcmxhcHBpbmcgd2l0aCBvdGhlciBzZXNzaW9ucy4NCg0KQXV0aGVu dGljYXRpb24gY2FuIHN1Y2NlZWQgZXZlbiBpZiBhdXRob3JpemF0aW9uIGZhaWxzLCBhbmQgaXQn cyB1c2VmdWwNCnRvIHNlZSB0aGF0IGluIHRoZSBsb2dzLiBJbiBtb3N0IGNhc2VzIHRoYXQgbG9v a3MgbGlrZSBhIGZhaWxlZCB1c2VyDQptYXBwaW5nLCBidXQgdGhlcmUgYXJlIG90aGVyIGNvcm5l ciBjYXNlcyB3aGVyZSB3ZSBmYWlsIHRoZSBjb25uZWN0aW9uDQphZnRlciBhIHN1Y2Nlc3NmdWwg YXV0aGVudGljYXRpb24sIHN1Y2ggYXMgd2hlbiB1c2luZyBrcmJfcmVhbG0uDQpDdXJyZW50bHkg eW91IGdldCBsaXR0bGUgdG8gbm8gZmVlZGJhY2sgd2hlbiB0aGF0IGhhcHBlbnMsIGJ1dCB3aXRo IGENCnNlcGFyYXRlIGxvZyBsaW5lLCBpdCdzIGEgbG90IGVhc2llciB0byBwaWVjZSB0b2dldGhl ciB3aGF0J3MgaGFwcGVuZWQuDQoNCihJbiBnZW5lcmFsLCBJIGZlZWwgcHJldHR5IHN0cm9uZ2x5 IHRoYXQgUG9zdGdyZXMgY29tYmluZXMvY29uZmxhdGVzDQphdXRoZW50aWNhdGlvbiBhbmQgYXV0 aG9yaXphdGlvbiBpbiB0b28gbWFueSBwbGFjZXMuKQ0KDQo+IFdpdGggdGhpcyB3ZSBzdG9yZSB0 aGUgc2FtZSB2YWx1ZSBhcyB0aGUgYXV0aG4gYW5kIGFzDQo+IHBvcnQtPmdzcy0+cHJpbmMsIGFu ZCBBRkFJQ1QgaXQncyBvbmx5IHVzZWQgb25jZS4gU2VlbXMgd2UgY291bGQganVzdA0KPiB1c2Ug dGhlIG5ldyBmaWVsZCBmb3IgdGhlIGdzc2FwaSB1c2FnZSBhcyB3ZWxsPyBFc3BlY2lhbGx5IHNp bmNlIHRoYXQNCj4gdXNhZ2Ugb25seSBzZWVtcyB0byBiZSB0aGVyZSBpbiBvcmRlciB0byBkbyB0 aGUgZ3NzYXBpIHNwZWNpZmljDQo+IGxvZ2dpbmcgb2YsIHdlbGwsIHRoZSBzYW1lIHRoaW5nLg0K PiANCj4gU2FtZSBnb2VzIGZvciBwZWVyX3VzZXI/IEluIGZhY3QsIGlmIHdlJ3JlIHN0b3Jpbmcg aXQgaW4gdGhlIFBvcnQsIHdoeQ0KPiBhcmUgd2UgZXZlbiBwYXNzaW5nIGl0IGFzIGEgc2VwYXJh dGUgcGFyYW1ldGVyIHRvIGNoZWNrX3VzZXJtYXAgLS0NCj4gc2hvdWxkbid0IHRoYXQgb25lIGFs d2F5cyB1c2UgdGhpcyBzYW1lIHZhbHVlPyBJU1RNIHRoYXQgaXQgY291bGQgYmUNCj4gcXVpdGUg Y29uZnVzaW5nIGlmIHRoZSBsb2dnZWQgdmFsdWUgaXMgZGlmZmVyZW50IGZyb20gd2hhdGV2ZXIg d2UNCj4gYXBwbHkgdG8gdGhlIHVzZXIgbWFwcGluZz8NCg0KU2VlbXMgcmVhc29uYWJsZTsgSSds bCBjb25zb2xpZGF0ZSB0aGVtLg0KDQotLUphY29iDQo=