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 1lNIOB-0004mF-AZ for pgsql-hackers@arkaria.postgresql.org; Fri, 19 Mar 2021 16:54:19 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lNIOA-0001Qf-7T for pgsql-hackers@arkaria.postgresql.org; Fri, 19 Mar 2021 16:54:18 +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 1lNIO9-0001QY-QA for pgsql-hackers@lists.postgresql.org; Fri, 19 Mar 2021 16:54:18 +0000 Received: from mail-bn8nam11on2085.outbound.protection.outlook.com ([40.107.236.85] helo=NAM11-BN8-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 1lNIO6-0006MS-5P for pgsql-hackers@postgresql.org; Fri, 19 Mar 2021 16:54:17 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=b2VcdKlSQpdEWcrzLuYBWKabZflC7fyJHGTX6plN9byiZsU95pW/UdkVqt3ipd5RzdL2qHYviYqKQoKexjL8+b96YTJh0ImFoNk9oGsTppSg5tOo67Bb2MO7uTpprHzFlfsM7OAFkXFPQyijbXXkSCYJR3bjB5XGigsEdFXG2uOFdeWkuosmg+Ok5DczWXMBmCL2Ih55Jhnbde5ogRr0KfmeyvOpiWbEshr2ajgYCVi9hqCCz/+1nxg2wOd8ngXMbQKdKRzAM3YYji9dH6+J9kuwlKBs6QRnB4xmyf+ijtz2MvZTtYaJzuvXxHe2FqHAyR7p8r8ibDnPtyRFPj+V+w== 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=lTC3Baay0VW7Y26QLDG6+Iz5qUHWv1cE0z4hWEDIbd0=; b=kONAoSwjB9pbvGBLgE0ruZX8J+MUBgvrbVfL5BPUNSB86eqA5OdQqWQUNlAOTUz2Vtm0Op0ZngIMTXrkmmYEvDFon2PPDXB5bwWNh8jQwSi2rTf2qBAPyWefXZ2Y2Bgcc9wiC/2YcQbtOx+yk5uc2i0GWxuQXuMOG9/WYYEcJTWevM9DkabnfGB4eYmnsP/Z/pL7rfPICDY5E/HRrqbXtW8RQ0dqpedneqpKyWXrZBG7hWhYgKXRMUZhIC07nj7pqY0a99Q/2fvX1QVZMR3zszKy5bvc34HtWwJxztXC+3xp/8VwNXxCjUW8eSLi5irSB6tCzIpsi0WGWOFgvfWl9w== 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=lTC3Baay0VW7Y26QLDG6+Iz5qUHWv1cE0z4hWEDIbd0=; b=WWWitx0x7wThXdAWrbhQHpIBCETTRn5jHvK9ygZh49UaSFMDHK2sHfoC6BDdrPW1gNeacMsfVz6ydm6ByxqNpVuHcdkU/30CKfmh0GZi++wBc8mrM8ogFodK/rXdT+Eiik3Z35dxsBAtGLh3wOiuCw1TuB3hegEPNR6X6+grhxk= Received: from MWHPR05MB2896.namprd05.prod.outlook.com (2603:10b6:300:65::20) by CO6PR05MB7538.namprd05.prod.outlook.com (2603:10b6:5:343::17) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.3977.9; Fri, 19 Mar 2021 16:54:11 +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.009; Fri, 19 Mar 2021 16:54:11 +0000 From: Jacob Champion To: "michael@paquier.xyz" CC: "magnus@hagander.net" , "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/fl6pFeJoAgAmCVACABIPmgIAXhdMAgAxttwCAA3O0AIABS40AgAAS9ACACTYWgIAEN3sAgAGUV4CAAI82AA== Date: Fri, 19 Mar 2021 16:54:10 +0000 Message-ID: <65354d28ec024d610ee7fe0128a69075d2092043.camel@vmware.com> References: <5d8b74e64fe4a610b23624277e497cc0a925db4b.camel@vmware.com> <2870147caa759155c5c8a232bbd2399f41f76491.camel@vmware.com> <4b2ca51542fa84e6fa37ab678624d5b400c092c0.camel@vmware.com> <679382aaff23627a2e53541322c7a3158d402394.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: paquier.xyz; dkim=none (message not signed) header.d=none;paquier.xyz; 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: b382453d-0f2f-4f8b-a970-08d8eaf79e95 x-ms-traffictypediagnostic: CO6PR05MB7538: 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: 85uMylHokfcqRqExa+qBZFwTe9ddoXr/maDr+2iwV8jlY7N9Ir5XuNrsiHSr77WnCK2786hLpdyEJR4sT457JAep0wibtXOQ6g/qUPIv9g/XJIclQjx5b1kQplOz/8YLvffT8P4clm8hGZg3do2AJrMOjCFP7rsmGiwfojkR1iyNmFbqvLLJq01hrxumeMPA6QDioP290FZSekaDFXoMufn75W6/XYqiqOC1veUXOHKn7NzV/+BdMWltmAaJIiQ3/cUdk7Lyl0uS1E1XauF3RPQdwcidVioCxnlR0OWGKq7vju2DwWRErksvjKMlkTUrZD6wgGgJss5yZ63LFIE7XEKLay6zkv0yJt+O+kNBreZd1SW364tWAJyRfmDzre37RCwdKN4J7AdUJQBf2MJDXW3ObUVK7FNQY6RtMWUDjVvSEX84S48TX8F4dA640KFRLxnuqInAxogq5BMU7aUJGpWUTYmzlyuCn/W1dhYbLlMQgeDmehgbCOzkn5GFU2MRaYK+gNJfKN/r6ZWRYzh5tJEGiI5UV4ve423he74Qm6O4Z7q1LnednXJho0I0S2ZWpceg+c9omVat3nwIj0e3X5Ee1IbLOE+BsQ2mt0BWn3bBS8grPnjwsXF213qff8jJEo5wuCJo+qqMiCNu06NEZ/EH0MpNcV6hBYQoqsEd6+5p1IPGS6IO2K0SerLB1a/ic6qu48p9L2YSQypZKzN+3UJtNlhtCdG+T2ElURsL4IRwo0iyrjSzrrblzwYqtm2f 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)(39850400004)(376002)(396003)(366004)(83380400001)(5660300002)(66556008)(86362001)(71200400001)(966005)(66946007)(6506007)(478600001)(186003)(26005)(64756008)(6916009)(8936002)(54906003)(2616005)(2906002)(6512007)(66446008)(6486002)(66476007)(36756003)(4326008)(76116006)(8676002)(38100700001)(316002);DIR:OUT;SFP:1101; x-ms-exchange-antispam-messagedata: =?utf-8?B?ckhGYzJzQ0Rmd0F5N3ZnbmNxY3FOc0dpd1plWTJOS3crYmZWRjMzY3JUNUhw?= =?utf-8?B?TlA4M0RGVitKZDhaTzNJeS9ZT0RLTVJCK3dYYnY3THc5ak5RWjl5dmdlZEkr?= =?utf-8?B?NUs1d3FVODhmckg0RHRmWWJEdnM5U25HTHRlNjI0c1d1cXp2VlFIclNFZWd2?= =?utf-8?B?YjRZR2xkVFk1NVZGdktnRG9YR1ZUUWxoSXRLSmZMM1RWUlFLajVpbDIyWHZx?= =?utf-8?B?YXVlNCtmeUpadE5uTU1XVlhJRis5dTB5YTZCWVB6Ym8zQUI3YlhnTGxhU0VX?= =?utf-8?B?Rm4rakVSeEhqaGlIcHBZNzRKZHdqTFQ4OUJpK3NzL1NKTnNVMkpGSk5TbU1x?= =?utf-8?B?RGNWeUVVRlVTd21kcm5udmd6VUpDWThpbWJMeUZNd2N5K1A4ZXArRGFTS0lC?= =?utf-8?B?U0duQ0QzM0lXZW82aVUvbUhUZzhFMHpnMGtzeXRESFdZdkw2QWh2cy9oMDEx?= =?utf-8?B?WnYwRXJlRHRMNjV2MFhQdHRoT00zMEQxZXBTQVE4M0UxSDFFSzRrNkRsY1lu?= =?utf-8?B?STdtYlhGa1h6M3BYN3FBTXBLTmZwQWxvNE4yQlNzRUdQcldVb2h3cXZWRmlL?= =?utf-8?B?OFAzSklrZ0l1RjFuSDI3Rk9TM3FFU2svR3V5NWFPNjFCRDBRNG5PaGRmSVVF?= =?utf-8?B?ekxhWTJabXA2aEVwWkRrL21IQkhTRm9hZFhGbGMzWnoxcnVxLzFCK0xjZk0w?= =?utf-8?B?cG9USVhrUy90dWRUbzFCZVVVUUxoZ0FYcThlaWlQRk9vcllLeFJTQ042TU1O?= =?utf-8?B?Z3FFL3VxZTBYMjlkQzBzei94aTdVb3Z6VEFpcHhUcXVxTTNsenVqYmFUMnZ3?= =?utf-8?B?VURodE9lTXJIdmc1SUVKYmEyay9LbGtBZzNJY3ZHcWd0ZjNMdFZFWEl0S2l2?= =?utf-8?B?bWIyaDJzcWwxODZYVGsvMHZMM0R5WC9mUTRocStNdUJ1ZlljaDBSZGs5VDZF?= =?utf-8?B?VkFqeVdweEdMZHREQ0lCWi9OZi9ZVTRPMHVVZGduUzVsREpQUENsZWVpcmpD?= =?utf-8?B?MVFpdWF1STd4SVRlS2RiTVlYRDNFS0U1VjdUMDFSVFRVTXpMR3NSNWxKaDBi?= =?utf-8?B?ckVKZlNzdHBMRHhSV1BPTndTa2VIQ3Y2MlRFNjRFSTJpNG9HNDRqUURWUDdV?= =?utf-8?B?L1lGTEt0OCtNZmJNV0o0S1NnR2sxRE0zWWxJeE5Gclprc1orek9ad1Z0WFBu?= =?utf-8?B?TW1lTGQ0eHRxTXRZUHpyR0RWaG8xdjdBd0ExWlhsM01uRnpVQ0liNEZkZ1Zy?= =?utf-8?B?UlJoa1hnZE1XVWVrT3JsVFRMTVhIRXZGM3phbUsyWnR4SHQxZGxRd2NoUHR5?= =?utf-8?B?bXpoVUF6QlUrdmwxaVZsRnZrQkxvSTVrenlLNE9vMEh3RS9Pc1RXN1BlV2Vw?= =?utf-8?B?bWxWNXVKQzdGUGg4YXArVXFJeVRzYTZWaFFsc3kvaXljcSttalFMNTBoRlJL?= =?utf-8?B?UFRLb1ZER0d1VGxPY2pqNmdaRmtsZitsNG5yVjZJWGx5TkNndnhPUGFUdkhP?= =?utf-8?B?bmRxRU5XQkd5YXpWcjhQazhUZ21KeW0xalM4cnA2eFdBNjNWV1Q3UVFuK1dR?= =?utf-8?B?eFZJLzU5ZlRhNVFPelplTXdnZmR2QWQ1ZW9KdTA3OENQaHIyMXdSNFZnYlVa?= =?utf-8?B?Nit5YllRNjZadHpXVXhmZHAzVEp2eGtaUUdQTnYyWUYzb08zZmkzMDdxOG5y?= =?utf-8?B?cnhPNmJSVHhWdFV3eXpzeFUwcnM4ZW5NdEVHRjNWblZDS3NBclNaejczSUdS?= =?utf-8?Q?ArWrILUMUNOv99RkFGeCAkQsrM4XamXyTiF26YV?= 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: b382453d-0f2f-4f8b-a970-08d8eaf79e95 X-MS-Exchange-CrossTenant-originalarrivaltime: 19 Mar 2021 16:54:11.0785 (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: /0QekliDKBlwtVGQiq7O/R81I/v3hfp33QsB4BlRWqVMyqBj0KyN539qncuGG0hKHETWorbUVOZh68QZgFzSgw== X-MS-Exchange-Transport-CrossTenantHeadersStamped: CO6PR05MB7538 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk T24gRnJpLCAyMDIxLTAzLTE5IGF0IDE3OjIxICswOTAwLCBNaWNoYWVsIFBhcXVpZXIgd3JvdGU6 DQo+IE9uIFRodSwgTWFyIDE4LCAyMDIxIGF0IDA1OjE0OjI0UE0gKzA5MDAsIE1pY2hhZWwgUGFx dWllciB3cm90ZToNCj4gPiBMb29raW5nIGF0IDAwMDEsIEkgYW0gbm90IG11Y2ggYSBmYW4gb2Yg cmVseWluZyBvbiB0aGUgcG9zaXRpb24gb2YgdGhlDQo+ID4gbWF0Y2hpbmcgcGF0dGVybiBpbiB0 aGUgbG9nIGZpbGUuICBJbnN0ZWFkIG9mIHJlbHlpbmcgb24gdGhlIGxvZ2dpbmcNCj4gPiBjb2xs ZWN0b3IgYW5kIG9uZSBzaW5nbGUgZmlsZSwgd2h5IG5vdCBqdXN0IGNoYW5naW5nIHRoZSBnZW5l cmF0aW9uIG9mDQo+ID4gdGhlIGxvZ2ZpbGUgYW5kIHJlbHkgb24gdGhlIG91dHB1dCBvZiBzdGRl cnIgYnkgcmVzdGFydGluZyB0aGUgc2VydmVyPw0KDQpGb3IgZ2V0dGluZyByaWQgb2YgdGhlIGxv Z2dpbmcgY29sbGVjdG9yIGxvZ2ljLCB0aGlzIGlzIGRlZmluaXRlbHkgYW4NCmltcHJvdmVtZW50 LiBJdCB3YXMgYnJpZWZseSBkaXNjdXNzZWQgaW4gWzFdIGJ1dCBJIG5ldmVyIGdvdCBhcm91bmQg dG8NCnRyeWluZyBpdDsgdGhhbmtzIQ0KDQpPbmUgYWRkaXRpb25hbCBpbXByb3ZlbWVudCBJIHdv dWxkIHN1Z2dlc3QsIG5vdyB0aGF0IHRoZSByb3RhdGlvbiBsb2dpYw0KaXMgc2ltcGxlciB0aGFu IGl0IHdhcyBpbiBteSBvcmlnaW5hbCBwYXRjaCwgaXMgdG8gcm90YXRlIHRoZSBsb2dmaWxlDQpy ZWdhcmRsZXNzIG9mIHdoZXRoZXIgdGhlIHRlc3QgaXMgY2hlY2tpbmcgdGhlIGxvZ3Mgb3Igbm90 LiAoU2ltaWxhcmx5LA0Kd2UgY2FuIG1hbnVhbGx5IHJvdGF0ZSBhZnRlciB0aGUgYmxvY2sgb2Yg dGVzdF9xdWVyeSgpIGNhbGxzLikgVGhhdCB3YXkNCml0J3MgaGFyZGVyIHRvIG1hdGNoIHRoZSBs YXN0IHRlc3QncyBvdXRwdXQuDQoNCj4gV2hpbGUgbG9va2luZyBhdCAwMDAzLCBJIGhhdmUgbm90 aWNlZCB0aGF0IHRoZSBuZXcga2VyYmVyb3MgdGVzdHMNCj4gYWN0dWFsbHkgc3dpdGNoIGZyb20g YSBsb2dpYyB3aGVyZSBvbmUgbWVzc2FnZSBwYXR0ZXJuIG1hdGNoZXMsIHRvIGENCj4gbG9naWMg d2hlcmUgbXVsdGlwbGUgbWVzc2FnZSBwYXR0ZXJucyBtYXRjaCwgYnV0IEkgZG9uJ3Qgc2VlIGEg cHJvYmxlbQ0KPiB3aXRoIHdoYXQgSSBzZW50IHByZXZpb3VzbHksIGFzIGxvbmcgYXMgb25lIGNv bnN1bWUgb25jZSBhIGxvZyBmaWxlDQo+IGFuZCBtYXRjaGVzIGFsbCB0aGUgcGF0dGVybnMgb25j ZSwgc2F5IGxpa2UgdGhlIGZvbGxvd2luZyBpbg0KPiB0ZXN0X2FjY2VzcygpOg0KDQpUaGUgdHJh ZGVvZmYgaXMgdGhhdCBpZiB5b3UgbmVlZCB0byBjaGVjayBmb3IgbG9nIG1lc3NhZ2Ugb3JkZXIs IG9yIGZvcg0KbXVsdGlwbGUgaW5zdGFuY2VzIG9mIG92ZXJsYXBwaW5nIHBhdHRlcm5zLCB5b3Ug c3RpbGwgbmVlZCBzb21lIHNvcnQgb2YNCnNlYXJjaC1mb3J3YXJkIGZ1bmN0aW9uYWxpdHkuIEJ1 dCBsb29raW5nIG92ZXIgdGhlIHRlc3RzLCBJIGRvbid0IHNlZQ0KYW55IHRoYXQgdHJ1bHkgKm5l ZWQqIHRoYXQgeWV0LiBJdCdzIG5pY2UgdGhhdCB0aGUgY3VycmVudCBwYXRjaHNldA0KZW5mb3Jj ZXMgYW4gImF1dGhlbnRpY2F0ZWQiIGxpbmUgYmVmb3JlIGFuICJhdXRob3JpemVkIiBsaW5lLCBi dXQgSQ0KdGhpbmsgaXQncyBuaWNlciB0byBub3QgaGF2ZSB0aGUgZXh0cmEgY29kZS4NCg0KSSds bCBpbmNvcnBvcmF0ZSB0aGlzIGFwcHJvYWNoIGludG8gdGhlIHBhdGNoc2V0LiBUaGFua3MhDQoN Ci0tSmFjb2INCg0KWzFdIGh0dHBzOi8vd3d3LnBvc3RncmVzcWwub3JnL21lc3NhZ2UtaWQvZjFm ZDljY2FmN2ZmYjIzMjdiZjNjMDYxMjBhZmVhZGQ1MGMxZGI5Ny5jYW1lbCU0MHZtd2FyZS5jb20N Cg==