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 1l6h2i-0001Gm-3s for pgsql-hackers@arkaria.postgresql.org; Mon, 01 Feb 2021 21:47:32 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1l6h2g-0003Ek-Pp for pgsql-hackers@arkaria.postgresql.org; Mon, 01 Feb 2021 21:47:30 +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 1l6h2g-00039N-Ac for pgsql-hackers@lists.postgresql.org; Mon, 01 Feb 2021 21:47:30 +0000 Received: from mail-eopbgr760059.outbound.protection.outlook.com ([40.107.76.59] helo=NAM02-CY1-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 1l6gs9-0000hj-Sn for pgsql-hackers@postgresql.org; Mon, 01 Feb 2021 21:36:39 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=eD9bU7p5ZzuKUeyFgAWsYkIaR6ye9+VdhmaH9HEzGr9UDD2y0ygTRQchHknlAUeGlrf/OM4arG1vfsPdPSaZT9xPXZa/7tIgZ+ynMzysco56QZYUImblOIWoqRxhv/SCxUPRwarGBpoxTbjHcTAFvMvYS3p/IndMFeWGaf/Rv0bI+nQEjDZ+RznUNKI4pwzGwaIdd2+OL5Wxg9L/Bt23DPKis0Tl2es25WEsaePZoiSyUUV1IWX70FuYdO7darxYWlT63frsFr0urMUFsGQZ9N6ex3JfZ9RwCsMG7udDgTWosb0REQRbScuHTqFWfyaqMkg8313f7CMEwiKGH7kCIg== 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=A1u6fJP1mfM5OgSjJZRtFOzIphCFQ5q7goV7ccmllmE=; b=ew80sIjfjmD0WTdQ/J8YcV5EbTQy3XhdnbFDX/RAbkj+c1sqTmHJshMNJfWakwtWqpc/Lyorz8zTLcIaUrHfD7UGVZw9mPipYE04L4c3Nxv+otIWkHgTa6B5Tdi+/GSVcug71Fe/oiwdbDmR75QLf1cOZgLEsgUhcSlBF+ePFM7MUJYTFCykIZFg44nXng+hoeJuOjPayoD3300alVvpSErGmxGL7WAkvFNCU2SQurE1FXEwsdKSseSxQhUJC/MkLQyMyowkLdJ/GzAZXjhDsrpXUyxS5RkqzrfX6gfaxh58igez1yr7qrYimzGXhzbPsmNgGGf55SA3u5eR1bp3rA== 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=A1u6fJP1mfM5OgSjJZRtFOzIphCFQ5q7goV7ccmllmE=; b=Nod5F2GpQdb1vNt2svytmnAgh5tA7X4uBNf0CfIRTwCdK3WZH45ULuDUnES0PE0Yw0PFHuAywnkidNQl2vWfppQdPuNLC8ojhTo+ddd48r2TAfkiGhO4mES0EfenVjA8lrVtv9AHfn9gFTvy43EPstj94ELAVuTcvEXPX7g+EiQ= Received: from (2603:10b6:300:65::20) by CO1PR05MB8101.namprd05.prod.outlook.com (2603:10b6:303:fa::14) 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 21:36:34 +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 21:36:34 +0000 From: Jacob Champion To: "magnus@hagander.net" CC: "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/KTGAgAAWgoCAAl07gIACPGuA Date: Mon, 1 Feb 2021 21:36:34 +0000 Message-ID: <94f6b945f9ca8cabe2b9d2a38ec19dca6f90a083.camel@vmware.com> References: <20210129220101.GE27507@tamriel.snowman.net> 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: 7c52b790-6864-4634-19cc-08d8c6f97291 x-ms-traffictypediagnostic: CO1PR05MB8101: 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: Ik8HSzcTMLiTsofeMwvwUvw8ueQajrR7o5a469VXx/6OYT4f0JqybW26qx5CGLznPzCTpCMlBfvjo+oKzWHRP14bJypMEiKQ8my9GHzGu/XTcNqiuqkUfKFqAWjHQ2Yt3DnVL6NUEEn8boyQirkezXInox8l2UOXdvoPgAah5BkWI5QVE0F6gYvAHnUaQepeffQdN7kVkrYE7v2AIBXKGbYF2Dt8V91U1lsa0eDzmwsmvkf9/te0fMGqSKa653CLMnhmbGyDyo6JHq8vf1LhGONat2azWpRrJuNFsrJpnWF/VpIdqWK8PtvcsnbhZ+0g0wDCMztNdby+3juD6bYWhN/07YyZTaKRP/MNCgp073lhYybSjzqVtT5MzifJDtiuJ9rZd56nYWb2o4L26FX7CUCkO/A9ypx9Gt/j9199WnOEyeOkYSBsyZvfs39xLtfk0lLZaxCoSwNnIeey1cblciPlSJ0XbDAs/ySJiYKAdEKr5Fqxbha8tccaI7zE1OVBhV45bYLdE4C9o/swqY/sOw== 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)(376002)(366004)(396003)(346002)(39860400002)(71200400001)(5660300002)(6486002)(316002)(86362001)(478600001)(186003)(6512007)(36756003)(54906003)(66446008)(76116006)(66476007)(2906002)(66946007)(8936002)(66556008)(64756008)(26005)(6916009)(4326008)(2616005)(83380400001)(6506007)(8676002);DIR:OUT;SFP:1101; x-ms-exchange-antispam-messagedata: =?utf-8?B?dXZQelZJbG8rdnIvMFJNVW5TNDBsZzN1aUlXcmQ5WWp1ekg3eW9aQnVWZlVv?= =?utf-8?B?RnBOcWdYblhVVWV0RUhHcXRrcXZHektIaU8rbXpHUTJEdUh6Qm1uay9YQ01w?= =?utf-8?B?QVRCVGpMczBSWHZmZEJjbWhnNk4yenpiWHh3ZjF5L3BKMlVXTDg0MXN6SXFx?= =?utf-8?B?WkQwMWY2dmZkcCs0VzlYNEZiS0MzQmhQb1BHMXhaZmJLUWNNTHdEQThSYW91?= =?utf-8?B?cnNKa2hYS0p5cG9oSDhNVlQxcUh1T2VLekp2by96VmdETVpUdUVrbUlQamVh?= =?utf-8?B?enI4Vi81SU03Ukg0OUc5RWFBZTZwWkhHemM5d0VjNXo1Rkg0byt1cWVKYjZv?= =?utf-8?B?dDBVYmNIaEVwWGJzeEdJcVBzNHRlY3BjK1pJVndDVmRLQUtyejlNSVQyQ1Nn?= =?utf-8?B?WUdpOFlhNktyY1V6KzFNOFAzQlBmTC9JK2hzVUdFdUJXa2M4UmhmZFJMMXJM?= =?utf-8?B?WDFLR1YzSm9uVTR5Mi9ENVZIbzBQSGdRUEtOMDdKdkFCVnljUnRaUnpib2Rs?= =?utf-8?B?OHFCbUk3UWRaVWRVOFB2Y3NzemhQNXVjZUg1UU9aN1E4TXJ5bXhUVEhQQW5a?= =?utf-8?B?Y2F4SFNIZkUvSHpRbWFQK3pXd1pVN0NBYVFvNXJjNk51WGhqMkhMS2NkRFNC?= =?utf-8?B?SXQxRzBHazhleGpDZkpPSXc2b1lEM1VISnZPWVhqMmlaUWxsTmZOSDN1WFoz?= =?utf-8?B?cnBaQ1EwaXFXbzVFVTY5bysxSlFjT2xwaVFMMHVLZThjUklKTmZJbmN5dnB0?= =?utf-8?B?c04welVVRUp1V1hhR0RTTkRyazlJbTl5UlAxTVIrZFdZL1JHQnVobkFoWlB2?= =?utf-8?B?T2Z0cHhkSHRSV2g2VnNGREg1c1diVk11U2xkVnNnTGQrTXg0ZTlOWUo0ZDc1?= =?utf-8?B?b05qUnA1M1FwakNsSGRqalpIOHFKV0pza016ZVRYd2JkWE5ydVc3US9LMU9G?= =?utf-8?B?ZUw3bDM4ZXFHVk1hbC9lY20rbTBwNmxkUlp0bkg1ZkExUHVmZU5KNGJKaXVy?= =?utf-8?B?ZHczemZNNjU0WDJVcXVIRmVubnNCMUlmdUY3VlRRemtqK1VXVW5EY2IwSmt5?= =?utf-8?B?ZmJHSWVIcmJleW9WbVFJTDMyRzlvZ0pWaTVTcUIvUGIyanR5SlFNbFpXejhO?= =?utf-8?B?WG1uYVVDK0NyUG13VjNjUVlPS3I4SHRlbWxDeWp4WWZBbkRRUEVmeWZIZ2Rx?= =?utf-8?B?OWZNMTF6NDE3ZzNsTjdMNkFEV3JhcmlvVWFZUjA3b2pGbWYybENaOVRWTGlS?= =?utf-8?B?MmMzdEtnbHRhODQ4ZUo3Z245V3pUSk5hVU5nazdCa2ZrZ2dZL1RXWE5QNWpo?= =?utf-8?B?OVY0OFN3WjVHeGtua3FXb3hoT2FzZ1NRUW5ncXhaMklhcFdWUUpiUXhqc3dL?= =?utf-8?B?YWZDcFFTb3owQ21KSEtaMTRiYWJEcEo3Y2RVeDQxaHhKNXExMXRGRnRncmRl?= =?utf-8?B?OVU1ZW8xUXB6UWZTOVdieUtZMHpmQ29vTW1KRnFnPT0=?= 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: 7c52b790-6864-4634-19cc-08d8c6f97291 X-MS-Exchange-CrossTenant-originalarrivaltime: 01 Feb 2021 21:36:34.3113 (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: c2TcVKUg2tRNVmBqTI9ioihj9uhWefkwfCUpGoEYMPKjI1j6pPz6jWxgXB4ubsqUKGxvPhB3r5V7A5QM601IvA== X-MS-Exchange-Transport-CrossTenantHeadersStamped: CO1PR05MB8101 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk T24gU3VuLCAyMDIxLTAxLTMxIGF0IDEyOjI3ICswMTAwLCBNYWdudXMgSGFnYW5kZXIgd3JvdGU6 DQo+ID4gKFRoZXJlJ3MgYWxzbyB0aGUgZmFjdCB0aGF0IEkgdGhpbmsgcGdfaWRlbnQgbWFwcGlu ZyBmb3IgTERBUCB3b3VsZCBiZQ0KPiA+IGp1c3QgYXMgdXNlZnVsIGFzIGl0IGlzIGZvciBHU1Mg b3IgY2VydHMuIFRoYXQncyBmb3IgYSBkaWZmZXJlbnQNCj4gPiBjb252ZXJzYXRpb24uKQ0KPiAN Cj4gU3BlY2lmaWNhbGx5IGZvciBzZWFyY2grYmluZCwgSSB3b3VsZCBhc3N1bWU/DQoNCkV2ZW4g Zm9yIHRoZSBzaW1wbGUgYmluZCBjYXNlLCBJIHRoaW5rIGl0J2QgYmUgdXNlZnVsIHRvIGJlIGFi bGUgdG8NCnBlcmZvcm0gYSBwZ19pZGVudCBtYXBwaW5nIG9mDQoNCiAgICBsZGFwbWFwICAgIC8u KiAgICBsZGFwdXNlcg0KDQpzbyB0aGF0IGFueW9uZSB3aG8gaXMgYWJsZSB0byBhdXRoZW50aWNh dGUgYWdhaW5zdCB0aGUgTERBUCBzZXJ2ZXIgaXMNCmFsbG93ZWQgdG8gYXNzdW1lIHRoZSBsZGFw dXNlciByb2xlLiAoRm9yIHRoaXMgdG8gd29yaywgeW91J2QgbmVlZCB0bw0KYmUgYWJsZSB0byBz cGVjaWZ5IHlvdXIgTERBUCB1c2VybmFtZSBhcyBhIGNvbm5lY3Rpb24gb3B0aW9uLCBzaW1pbGFy DQp0byBob3cgeW91IGNhbiBzcGVjaWZ5IGEgY2xpZW50IGNlcnRpZmljYXRlLCBzbyB0aGF0IHlv dSBjb3VsZCBzZXQNClBHVVNFUj1sZGFwdXNlci4pDQoNCkJ1dCBhZ2FpbiwgdGhhdCdzIG9ydGhv Z29uYWwgdG8gdGhlIGN1cnJlbnQgZGlzY3Vzc2lvbi4NCg0KPiBXaXRoIHRoYXQgSSB0aGluayBp dCB3b3VsZCBhbHNvIGJlIHVzZWZ1bCB0byBoYXZlIGl0IGF2YWlsYWJsZSBpbiB0aGUNCj4gc3lz dGVtIGFzIHdlbGwgLS0gZWl0aGVyIGFzIGEgY29sdW1uIGluIHBnX3N0YXRfYWN0aXZpdHkgb3Ig bWF5YmUganVzdA0KPiBhcyBhIGZ1bmN0aW9uIGxpa2UgcGdfZ2V0X2F1dGhlbnRpY2F0ZWRfaWRl bnRpdHkoKSBzaW5jZSBpdCBtaWdodCBiZQ0KPiBzb21ldGhpbmcgdGhhdCdzIGludGVyZXN0aW5n IHRvIGEgc21hbGxpc2ggc3Vic2V0IG9mIHVzZXJzIChidXQgdmVyeQ0KPiBpbnRlcmVzdGluZyB0 byB0aG9zZSkuDQoNCkFncmVlZCwgaXQgd291bGQgc2xvdCBpbiBuaWNlbHkgd2l0aCB0aGUgb3Ro ZXIgcGVyLWJhY2tlbmQgc3RhdHMgZnVuY3Rpb25zLg0KLS1KYWNvYg0K