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 1l6h65-0001Ob-BX for pgsql-hackers@arkaria.postgresql.org; Mon, 01 Feb 2021 21:51:01 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1l6h64-0005Vl-A8 for pgsql-hackers@arkaria.postgresql.org; Mon, 01 Feb 2021 21:51:00 +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 1l6h63-0005Vb-VF for pgsql-hackers@lists.postgresql.org; Mon, 01 Feb 2021 21:51:00 +0000 Received: from mail-bn8nam11on2049.outbound.protection.outlook.com ([40.107.236.49] helo=NAM11-BN8-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 1l6h61-0000Dj-0I for pgsql-hackers@postgresql.org; Mon, 01 Feb 2021 21:50:58 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=Nu4iRWwl7mkxhVQECFhe1jQAGhr2hghZ00CDHH6Umt4r26M8atNpD9hjefAlGrgSGQtYsfqArmabKGXF5o3XQobjYtE5jmHNoUS/USwgZVyUHsp7dExuWj8+Kr/8RRPQJLeBaGLKZBV9+QGmkQ+3KiMTDfFjKYpxq9mZCEY2ZzmVP2fTVQDddr/n5QoTYSo7ZjypeDz3BizchBACTVF+Bg9lztME3mT3IisJlIO3nKeOv98D98qUt7zBrnmKzjJZlXJDLW3oEoFs0rjg6qKV9DWf7ACjqFP7KvK1WeDIWxfRgl0VNyMJljsQsohmcvu4yHD1abbJFhIjt3b6hc/SwQ== 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=bsYW4Q9mFxTyCCejjloVXstpwHQbOkXACA2X523rxZE=; b=YjYyjVhFMm4VgIyd6a7HAHEsOF03MaDD/YAqzQFNdJOVR8PzuOK4rRlkDc3RJcOTAMXt8raGvw6eSuAYcQDAkDTO0yUTMOuuXGxKLp2m3zB0BQgBTg2p7fszUikhKzDgmEsxkEtNwoT4XtVKuTdy6Yv4DIIu0nbEuF71n7ATf65bVKOPtAQMXBi4EUN86g+ONR/Q4bttoxg/zMEhfR3wxC2lEDNorELQ5zfwz6P/KyvXKcM4BS3/0DKibncS/lsVq1zLQmZwhspEvVORNWICscD8+Yg9Dk/V1RwEJyXvNQ0zg2+rIqU/sT1flXJ2f/2VAX4j8bDrv7TCMmxuE7atMw== 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=bsYW4Q9mFxTyCCejjloVXstpwHQbOkXACA2X523rxZE=; b=OudQxzZr93oBbazZ7OAmKZYQ2TZSDcSa6mmOmjUGU33WyXbMhi7u2wC5A0bxK2aR3NqZr7F54/KKit0Ozf3YJ8aMgnCc/vT4JMaK8nwWnva2s+V9LKs6Am456W92F4ALO7iNhnVuNUAcVUrVKJkaBOh446z+tcm2Xwi7mVHsgq0= Received: from (2603:10b6:300:65::20) by MWHPR0501MB3899.namprd05.prod.outlook.com (2603:10b6:301:7d::21) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.3805.6; Mon, 1 Feb 2021 21:50:54 +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:50:54 +0000 From: Jacob Champion To: "magnus@hagander.net" , "sfrost@snowman.net" CC: "pgsql-hackers@postgresql.org" 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/KTGAgAAWgoCAAl07gIAB7BqAgABUUoA= Date: Mon, 1 Feb 2021 21:50:54 +0000 Message-ID: <57b741e9388f3bd97486615ea1f968c8eee9f055.camel@vmware.com> References: <20210129220101.GE27507@tamriel.snowman.net> <20210201164905.GI27507@tamriel.snowman.net> In-Reply-To: <20210201164905.GI27507@tamriel.snowman.net> 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: 9ba8d7b1-5b17-481f-1b0b-08d8c6fb7342 x-ms-traffictypediagnostic: MWHPR0501MB3899: 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: Ldkg/VDMLF6SsiAVdQO6JDZf12GU+cCs0Sgouikpo6fFMnNM03mHEQ9nSGVEHgQTRzWwZh+npSW3pYCXrslMzTQqqhJL4BN2OgDCbm7LhOUofluIn80V6L/Vwlb6q7g8Zy3KipS8NMmvsLqiPqu+EvEOZrf/WzhMACqOZd36MtqiDSwsXwb80q3qU6q/Aoj9kIAHxydNU0UyCqcAolXaqtRvf6F08qWUs/vgESb4jPNvLK8p5583i95cAeNDeSxzEU+3YcfBkfuHXd8yySfT7PMeCYdwQ9ikX3cWFPp+cpbGtjeFdoOVr3ol1ZdyQUJU/xby5cspNhiEXHT8N5bHEp2RLt36CEfT/l4HoKo3C2zr6EmYmS8Al8KhE95fFnAUu75jARdxFIbbMkbu7+JknKqjk37sttBmMTZqyfXV81mcTTSg4JcBV4ENTPg8RDahicC5cXyOvIYZpuWZXsBi24cM08d8KCLakO8K5/SpVTnFMeUvITb/tXLlEpKa9TqYJjDPPVzNymCTEQrJWgzTWw== 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)(39860400002)(346002)(396003)(366004)(86362001)(2616005)(83380400001)(316002)(6506007)(26005)(8936002)(66946007)(478600001)(64756008)(71200400001)(6486002)(5660300002)(6512007)(8676002)(66476007)(186003)(66556008)(36756003)(4326008)(66446008)(76116006)(2906002)(110136005);DIR:OUT;SFP:1101; x-ms-exchange-antispam-messagedata: =?utf-8?B?WElQK3lVZ2NiOVpXa0ZOODA3MzVZbGtvS1FJanFsbWU1dEZOVFhsVmlMSlNv?= =?utf-8?B?MmhlbWhXMnBiMUd3d3VncUhQYjJGeDkrZXJWVjZnNGJtRCtTb2hsY0YxNEdN?= =?utf-8?B?WGR0Z1Iybk83eUxCc1pNWFpqUGRMdU5SbjFpUHI2Rzl6RG56MFBNUFNKNEVN?= =?utf-8?B?TUdSTFJYWTdwUWQzb0xuZ3UzZnEvc2YwRTc5T1JwRy9MeDNLVkp0bWQ5RVFO?= =?utf-8?B?d1plUHgxOVBRZW9XT2Nsc3NmdGVDRFVFSWNrcmJYRHhQT3MrM2VTTno2VWN0?= =?utf-8?B?bFVTRU9wZ3VWVHVXdnpFTytvWEhidzJTZnJhbFV3b0dsVE4wd0ZrNmcraU1F?= =?utf-8?B?UDdCcktpcWJ1NTl4SjlXWVlxNVFsSFpCdmJUMXBRWHdsNTJVbW8zNHpBUm1B?= =?utf-8?B?c2RGNHhGcVVqaFdPZzZBeVNoeDgyMzFRbi9icW1WMkFRTGRSUGU1VDd2cjZj?= =?utf-8?B?Y0tkU0ZWVnYrQ0krMUZqT3ZqOUI1RWxnYks4N3N2VnF4cXFIbVVudXlxdkp6?= =?utf-8?B?OThMeVJUdUhkL1dDSUtCTjQvSzhEeTNFVkpkQlJ5QjlQeXc2eUxTcXZmWDFK?= =?utf-8?B?QkJQc2I5dTJzUll0RGVNNHZ3VnZxQnV3YkJSbGYyRGNJMFlVTzVtNW1lTmFm?= =?utf-8?B?N2FFWDNiOTdOa25SYXVLY2Qvblo3SUVFcEc4dTVQWWFhWnRCck9yNEFHcVc5?= =?utf-8?B?bE5qWExoanozRVEvL0IzTmZIRlZPS0o5Nk10cFpPM0xMYUhJMDJWOEZLUVlD?= =?utf-8?B?cTJMb0R5OFN2bkFWdzc0VU04Q0VnbkFPQTVGVlhWWDduT0JQcENQWDBCK0lO?= =?utf-8?B?TVliS0ZhNENldms2WUNjZUJ1M1BVS1BiR3Budi96WFkyM05LdHVNRTVad2tH?= =?utf-8?B?NTBSU3hsdlEwa1RyaDZyaDF6ZjF2akIrdG5XK0FRenI2bEh6d1BhSDdlb3hh?= =?utf-8?B?ODN4SXBvNW5OOGZvajZTTlVUY0Q4ZGNZTDlLR3d6RVdXdXIyYW5kL2E4b1FK?= =?utf-8?B?TnR2c2IrZ3FCamlHQmRKVlRhbFlqOVlWZ1ZtZHBrNGsxY0Q0SHpmM0YxL1dm?= =?utf-8?B?ZVhoaWRoSVk0eDNycVpJTURhaUEvZG9KZXU3ZENkRFlmUHFQU0tUMThwZEsy?= =?utf-8?B?MGdDTkVEWVJUTzlSRDROWDVSc0xCVU9MV3FZdUwrK1BKc3hLMlVZVVlHM2xE?= =?utf-8?B?MkQ0dDZwQzkwN3lQL3VoODVra29GeVRkZG9OYmppVk5ORkVpcDhsUDhramVU?= =?utf-8?B?eEpJQzdRdTBBMFVvd21mMlgvVkpmaXlLd3BtNXM3Yk9idzFKanRuT0lKMjhM?= =?utf-8?B?M29WTi8wcVRPbGRxWktWclphdC9CcUJEOEIwTUthWnBKWks2QmFMQ1BlSkxk?= =?utf-8?B?enJBNWhiREJaUStMUVFqQUN4azVYTWlZTWpENFZPM291VzhjMlluWVpWSkVo?= =?utf-8?B?RUFWdlJpSXRmTk5tWFc0cHcyUmpQTVAzS09WU3RRPT0=?= 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: 9ba8d7b1-5b17-481f-1b0b-08d8c6fb7342 X-MS-Exchange-CrossTenant-originalarrivaltime: 01 Feb 2021 21:50:54.4408 (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: xykfCA7d/rdjhEdxLfpIaMsmiOWIl4P+SxSaq/OZ7ijWHYiDsCfMs+N8cGgZzypVZjXVK3RRIZGEmPsb0vxvtA== X-MS-Exchange-Transport-CrossTenantHeadersStamped: MWHPR0501MB3899 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk T24gTW9uLCAyMDIxLTAyLTAxIGF0IDExOjQ5IC0wNTAwLCBTdGVwaGVuIEZyb3N0IHdyb3RlOg0K PiAqIE1hZ251cyBIYWdhbmRlciAobWFnbnVzQGhhZ2FuZGVyLm5ldCkgd3JvdGU6DQo+ID4gQnV0 IHllcywgSSB0aGluayB0aGUgZW5mb3JjZWQgY2xlYXJ0ZXh0IHBhc3N3b3JkIHByb3h5aW5nIGlz IGF0IHRoZQ0KPiA+IGNvcmUgb2YgdGhlIHByb2JsZW0uIExEQVAgYWxzbyBlbmNvdXJhZ2VzIHRo ZSBpZGVhIG9mIGNlbnRyYWxpemVkDQo+ID4gcGFzc3dvcmQtcmV1c2UsIHdoaWNoIGlzIG5vdCBl eGFjdGx5IGEgZ3JlYXQgdGhpbmcgZm9yIHNlY3VyaXR5Lg0KPiANCj4gUmlnaHQtIHBhc3Npbmcg YXJvdW5kIGEgdXNlcidzIHBhc3N3b3JkIGluIHRoZSBjbGVhciAob3IgZXZlbiB0aHJvdWdoIGFu DQo+IGVuY3J5cHRlZCB0dW5uZWwpIGhhcyBiZWVuIHN0cm9uZ2x5IGRpc2NvdXJhZ2VkIGZvciBh IHZlcnkgbG9uZyB0aW1lLA0KPiBmb3IgdmVyeSBnb29kIHJlYXNvbi4gIExEQVAgZG9lcyBkb3Vi bGUtZG93biBvbiB0aGF0IGJ5IGJlaW5nIGENCj4gY2VudHJhbGl6ZWQgcGFzc3dvcmQsIG1lYW5p bmcgdGhhdCBzb21lb25lJ3MgZW50aXJlIGlkZW50aXR5IChmb3IgYWxsDQo+IHRoZSBzZXJ2aWNl cyB0aGF0IHNoYXJlIHRoYXQgTERBUCBzeXN0ZW0sIGF0IGxlYXN0KSBhcmUgY29tcHJvbWlzZWQg aWYNCj4gYW55IG9uZSBzeXN0ZW0gaW4gdGhlIGVudmlyb25tZW50IGlzLg0KDQpTdXJlLiBJIGRv bid0IGRpc2FncmVlIHdpdGggYW55dGhpbmcgeW91J3ZlIHNhaWQgaW4gdGhhdCBwYXJhZ3JhcGgs IGJ1dA0KYXMgc29tZW9uZSB3aG8ncyBpbXBsZW1lbnRpbmcgc29sdXRpb25zIGZvciBvdGhlciBw ZW9wbGUgd2hvIGFyZQ0KYWN0dWFsbHkgZGVwbG95aW5nLCBJIGRvbid0IGhhdmUgYSBsb3Qgb2Yg Y29udHJvbCBvdmVyIHdoZXRoZXIgYQ0KY3VzdG9tZXIncyBJVCBkZXBhcnRtZW50IHdhbnRzIHRv IHVzZSBMREFQIG9yIG5vdC4gQW5kIEknbSBub3QgaG9sZGluZw0KbXkgYnJlYXRoIGZvciBMREFQ IHNlcnZlcnMgdG8gc3RhcnQgaW1wbGVtZW50aW5nIGZlZGVyYXRlZCBpZGVudGl0eSwNCnRob3Vn aCB0aGF0IHdvdWxkIGJlIG5pY2UuDQoNCj4gQWxzbywgaWYgd2UgZG8gYWRkDQo+IGl0LCBJIHdv dWxkIHRoaW5rIHdlJ2QgaGF2ZSBpdCB1bmRlciB0aGUgc2FtZSBjaGVjayBhcyB0aGUgb3RoZXIN Cj4gc2Vuc2l0aXZlIHBnX3N0YXRfYWN0aXZpdHkgZmllbGRzIGFuZCBub3QgYmUgc3VwZXJ1c2Vy LW9ubHkuDQoNCkp1c3QgdGhlIHN0YW5kYXJkIEhBU19QR1NUQVRfUEVSTUlTU0lPTlMoKSwgdGhl bj8NCg0KVG8gZG91YmxlLWNoZWNrIC0tIHNpbmNlIGdpdmluZyB0aGlzIGFiaWxpdHkgdG8gdGhl IHBnX3JlYWRfYWxsX3N0YXRzDQpyb2xlIHdvdWxkIGV4cGFuZCBpdHMgc2NvcGUgLS0gY291bGQg dGhhdCBiZSBkYW5nZXJvdXMgZm9yIGFueW9uZT8NCg0KLS1KYWNvYg0K