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 1l5d5J-0004j2-9D for pgsql-hackers@arkaria.postgresql.org; Fri, 29 Jan 2021 23:21:49 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1l5d5H-0007TI-3b for pgsql-hackers@arkaria.postgresql.org; Fri, 29 Jan 2021 23:21:47 +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 1l5d5G-0007SQ-Gn for pgsql-hackers@lists.postgresql.org; Fri, 29 Jan 2021 23:21:46 +0000 Received: from mail-bn8nam12on2052.outbound.protection.outlook.com ([40.107.237.52] helo=NAM12-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 1l5d59-0001aw-AE for pgsql-hackers@postgresql.org; Fri, 29 Jan 2021 23:21:45 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=KZjDAcbpYMXHZWHc5v3soP21bnFsfe3nOmzVuEnFFHaX+It9Pxs3v2JfhaXPX75PSKoEn6fxusptTOcTl85ARNL/n9bNpDmn+6YQmlsI0DnsAAqFTM+lBq0QaJ+CI1xE5p81lrRLVM1NX+J8HwZtf5AidsbwqM6wPwqtzmH5Uk9Lyq3g7NWJmeZYX+vmemGPVQf7mKw2E2//cXaHLS0hYxpE4VYVn8F/BgUrTFEgKGNP+2qpf/+gziFdviSQ3pI5W468Un1dK7iakW6DR2f0vqOxOhRy6W64CRU+HYbbeMs439jwMLala3pz3q5f16+twT0lTORTqrtlgf3Q7Yq/Og== 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=3afSxfTQZlYiqHgSGETTXia22ozMHDOQr8DtIF3FIx8=; b=BrcJpCtHWpFtoeKMq0ZdrmjSOtyssnD9P6Xg1tHo6fNknHqhQEktNGaIoY3xw03LiO6AQSiagg/qE00wJt1Ufu92DcWgqNjOJ+huPHpqvc/lnkyj22iTu6lrNWy/v6/1S9xt59c2aGY6N2DYLrF078hNArS+bG1oeA4kc+Rg5g3HqZes6WBdUduuzBI864WMpCAGrTjsdIlWGp7jQsGTFMXoo6G4vZynlMETR/sOScpNAHYaSEPthZwtOhbfTF+CndEuggTMT6wlqnBLRrrtRTg91vnvufqEv+hE9MiIjHrls55OM5XaSCII2hJs2ETNXE1D0cnszGgTp/pymboAew== 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=3afSxfTQZlYiqHgSGETTXia22ozMHDOQr8DtIF3FIx8=; b=MpHf+lwE1dBuXZh0wU5m9zyipspr2HGMAGYNjIwPpszkqrYyTezuVDfNXxKK47gNS1m3sKlO8DqUcXEh0wiUV43kQcQYtJgU4/X0eabkLr0jTlgBez4u485bZtCGETA1wM2Qejm0aazVma5EYneDJLKmWyxzgWv9PQBbuz6ST40= Received: from (2603:10b6:300:65::20) by MWHPR05MB3247.namprd05.prod.outlook.com (2603:10b6:300:b3::9) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.3825.8; Fri, 29 Jan 2021 23:21:36 +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.008; Fri, 29 Jan 2021 23:21:36 +0000 From: Jacob Champion To: "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/KTGAgAAWgoA= Date: Fri, 29 Jan 2021 23:21:36 +0000 Message-ID: References: <20210129220101.GE27507@tamriel.snowman.net> In-Reply-To: <20210129220101.GE27507@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: snowman.net; dkim=none (message not signed) header.d=none;snowman.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: f94c76dc-50e7-499d-12b5-08d8c4ac9fae x-ms-traffictypediagnostic: MWHPR05MB3247: 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: v2pnppy64y9gfN049Kbk1ahs1vtYy8qWw0zR3ueY1B7hLl5W5YOjcB740ZOhBCBJ2HELDIajdXFjLmqy3jh08NVuJ72BJNptOi7sB8BrFs9Tc6flbX2Lc5vqPW4yJIevkEua7pU1f90AA1WgUmgDIP6dieeoNPN61ckPG4XGlGHaJ/hZ81hVvF7WxcjN3HlJ1m8ixLgIIPPJDkXNnkOkwadB2dV9L0w6VqP07kRv875H8cDvi/kbUbMBlM3iibUTpDxs4C1uuu0reKeqMYCPhJ/bKPfSRDLvWJlvpNs/2ftPlchDa8OWZU7tAEYA6oH3EAhdEaWxvf9+OEke6HoR5tnUa/CO1e+25Fvy+LtCO2oaLEc6Z2DjRdBebYn6jrv10JCIPl0Y7hYRC6aoBW1LDz4HqQv2r/Erhm6a20pYcMElscQJ8DSIhQIQ9yQJK91gn2PcxmYdDF2LD+NIVt7RXaBOeDWD9zGa5kaYTFX4g+hrzu4SUQX+sVr5e3v0cT3GOP+cCzfMoRdw1TK35vAqew== 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)(376002)(136003)(346002)(396003)(39860400002)(366004)(6512007)(83380400001)(4326008)(8676002)(6916009)(2906002)(6486002)(8936002)(36756003)(316002)(66476007)(64756008)(66556008)(26005)(66446008)(6506007)(2616005)(86362001)(186003)(478600001)(5660300002)(71200400001)(76116006)(66946007);DIR:OUT;SFP:1101; x-ms-exchange-antispam-messagedata: =?utf-8?B?REVrSnQya1VZemxtY2ppTW1uSGFONFRXVEhmeWYvcFpkb0o2K1hOdzQyeHdt?= =?utf-8?B?eXpqYXZhb045S3RRQUZzL0F4M3dJcTFPakFsSTNWbU5tVzJRTkI3VkhjbG85?= =?utf-8?B?LzhwVnBaZVh2VWZXQ0lEd1gxYzFVdW1sRFB0VjVraEJXeTMrcHlqQkdCM2FE?= =?utf-8?B?Q2ttbTlJV2lxcENpRVQvMjd4bEhHOVZ4OHZsV3RSTm4zRGpHUmFqVmZXZCt6?= =?utf-8?B?THRPbjJUcDE3R2tINmoveWVwSHBQak5pN0dKVWdCTE1LL2FVcjlDVWxFZERr?= =?utf-8?B?TWRqZVBXVFlnU3pFUFgyRndjSklnR2hrbnFBR0E1MFlSaGdBYVlzSDVBdk1L?= =?utf-8?B?RytqMXZZK1BSMmJRczFpenlKZkdMOGdtSjByanVzTWFxYXN4cHA3R0Roc1l6?= =?utf-8?B?ZHA4dWtrejNqYWZ1ZmgrTDE0b3Bpd29CaTJqVHlMbVR2bk9YRnVGYnplclBk?= =?utf-8?B?cXBMWFFTbm8vS0xhSXlUU0N2MHp1VmdZSUErMEhhODhtcXJYb1pZcUpFMHZh?= =?utf-8?B?ZWpkUVlaS25NbjhIbnBvaVV0RTBQdnJzVk53UUZDWjBNU3dYWkhrYSswWW1Q?= =?utf-8?B?aXkvclU1QWtkQzRhdGg1SlJhcmc4bS9kOThYQmVBb1J2VE1nUUtaSm5PWFpU?= =?utf-8?B?WkdTWUU4U3BZaXVFUncvTU1yTlR4ck5iTDlreWhlSTlTQmVXWkZWZVBvZGtO?= =?utf-8?B?S3RBR3VUaHJsMHZHUjY4WDBxYlRHdlorVm1YRDR0N3Q3SGxVS2krMEthVm5p?= =?utf-8?B?YlN6Wi9CUnJVQ2ZyZnpTbjd1c2I4cERGbUJtQ0VMdHNhN2tSM3BEdnF3OWNO?= =?utf-8?B?Y3dUelNIOGdTV1JDRnZOOG5oN01LM0MzUkgwVnFzUlEzTEphV3JJL1R5UzZl?= =?utf-8?B?KzA4ejVicVFEZ05Sd1RNQmI5WGhGeE5IR0V2ZjdxeHpMSERTRDF4N2tFaE0v?= =?utf-8?B?YjR1UGlZRCt0aEpLdmtldGd5WW16NXBUYUlFK0o3U3RJN2ZBTWMzQzdhMzVQ?= =?utf-8?B?Y0c1K2dsZUQ1MkdEa1pVa25VRkR3enB3ZENxTUFsK2tvYVhTN1RyWEJYbDJW?= =?utf-8?B?MjBRRTNOdXBLVklON21IUTk4aE50bSt5QzQ3OW9STEx3UjBHU2ZZNytFbmR2?= =?utf-8?B?emZBcm15RXM3UDhFeGpHblNDNHBYZEZpdGlYWU1Hc2VkRWNjNnZKbE1VaGp2?= =?utf-8?B?ZFRjQVUyWEo5ZXVjOFFyV3FXRzN6NWJ5NGVIUFZkemhISzhpUmg0VHlpQnhH?= =?utf-8?B?aWN3N2U4aDRIVnhZMXNuUHl1N0RFaTQ5ZUxqT1YwTmlUYSsvcm4vaGJGZWJN?= =?utf-8?B?cmQ3RjFYd1BYNzdpOExUKzRvM2RaUnJheTdoTTkxdGpPK1JKRmo1WnZXRUhM?= =?utf-8?B?bU9XemhWZ2J2MzlnOEpwakNYKytrcy9JKyt1RFF0akJVQjEwQ0swS1pHbEpp?= =?utf-8?B?ZEpTc2szNmtYbk8xRjFydHJPRmdLUmxRazFZOFZ3PT0=?= x-ms-exchange-transport-forked: True Content-Type: text/plain; charset="utf-8" Content-ID: <8FE813A5EDFF4946958FE88C899952B9@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: f94c76dc-50e7-499d-12b5-08d8c4ac9fae X-MS-Exchange-CrossTenant-originalarrivaltime: 29 Jan 2021 23:21:36.3850 (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: bhc39kzuUu7jGfmISFiD6mv4kOQZ0E1D7iqXMwaX0vB3Ib8uVft9rmQEmEO/4Relzc+mu5SQKKSVUWZHcPLIcA== X-MS-Exchange-Transport-CrossTenantHeadersStamped: MWHPR05MB3247 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk T24gRnJpLCAyMDIxLTAxLTI5IGF0IDE3OjAxIC0wNTAwLCBTdGVwaGVuIEZyb3N0IHdyb3RlOg0K PiA+IC0gZm9yIExEQVAsIHRoZSBiaW5kIEROIGlzIGRpc2NhcmRlZCBlbnRpcmVseTsNCj4gDQo+ IFdlIGRvbid0IHN1cHBvcnQgcGdfaWRlbnQuY29uZi1zdHlsZSBlbnRyaWVzIGZvciBMREFQLCBt ZWFuaW5nIHRoYXQgdGhlDQo+IHVzZXIgcHJvdmlkZWQgaGFzIHRvIG1hdGNoIHdoYXQgd2UgY2hl Y2ssIHNvIEknbSBub3Qgc3VyZSB3aGF0IHdvdWxkIGJlDQo+IGltcHJvdmVkIHdpdGggdGhpcyBj aGFuZ2UuLj8NCg0KRm9yIHNpbXBsZSBiaW5kcywgdGhpcyBnaXZlcyB5b3UgYWxtb3N0IG5vdGhp bmcuIEZvciBiaW5kK3NlYXJjaCwNCmxvZ2dpbmcgdGhlIGFjdHVhbCBiaW5kIEROIGlzIHN0aWxs IGltcG9ydGFudCwgaW4gbXkgb3Bpbmlvbiwgc2luY2UgdGhlDQptZWNoYW5pc20gZm9yIGRldGVy bWluaW5nIGl0IGlzIG1vcmUgb3BhcXVlIChhbmQgbWF5IGNoYW5nZSBvdmVyIHRpbWUpLg0KDQpC dXQgYXMgVG9tIG5vdGVkIC0tIGZvciBib3RoIGNhc2VzLCBpZiB0aGUgcm9sZSBuYW1lIGNoYW5n ZXMsIHRoaXMNCm1lY2hhbmlzbSBjYW4gc3RpbGwgaGVscCB5b3UgYXVkaXQgd2hvIHRoZSB1c2Vy IF9hY3R1YWxseV8gYm91bmQgYXMsDQpub3Qgd2hvIHlvdSB0aGluayB0aGV5IHNob3VsZCBoYXZl IGJvdW5kIGFzIGJhc2VkIG9uIHRoZWlyIGN1cnJlbnQgcm9sZQ0KbmFtZS4NCg0KKFRoZXJlJ3Mg YWxzbyB0aGUgZmFjdCB0aGF0IEkgdGhpbmsgcGdfaWRlbnQgbWFwcGluZyBmb3IgTERBUCB3b3Vs ZCBiZQ0KanVzdCBhcyB1c2VmdWwgYXMgaXQgaXMgZm9yIEdTUyBvciBjZXJ0cy4gVGhhdCdzIGZv ciBhIGRpZmZlcmVudA0KY29udmVyc2F0aW9uLikNCg0KPiBJJ20gYWxzbyBqdXN0IGdlbmVyYWxs eSBub3QgdGhyaWxsZWQgd2l0aA0KPiBwdXR0aW5nIG11Y2ggZWZmb3J0IGludG8gTERBUCBhcyBp dCdzIGEgZGVtb25zdHJhYmx5IGluc2VjdXJlDQo+IGF1dGhlbnRpY2F0aW9uIG1lY2hhbmlzbS4N Cg0KQmVjYXVzZSBQb3N0Z3JlcyBoYXMgdG8gcHJveHkgdGhlIHBhc3N3b3JkPyBPciBpcyB0aGVy ZSBzb21ldGhpbmcgZWxzZT8NCg0KPiA+IEkgcHJvcG9zZSB0aGF0IGV2ZXJ5IGF1dGggbWV0aG9k IHNob3VsZCBzdG9yZSB0aGUgc3RyaW5nIGl0IHVzZXMgdG8NCj4gPiBpZGVudGlmeSBhIHVzZXIg LS0gd2hhdCBJJ2xsIGNhbGwgYW4gImF1dGhlbnRpY2F0ZWQgaWRlbnRpdHkiIC0tIGludG8NCj4g PiBvbmUgY2VudHJhbCBsb2NhdGlvbiBpbiBQb3J0LCBhZnRlciBhdXRoZW50aWNhdGlvbiBzdWNj ZWVkcyBidXQgYmVmb3JlDQo+ID4gYW55IHBnX2lkZW50IGF1dGhvcml6YXRpb24gb2NjdXJzLiBU aGlzIGZpZWxkIGNhbiB0aGVuIGJlIGV4cG9zZWQgaW4NCj4gPiBsb2dfbGluZV9wcmVmaXguIChJ dCBjb3VsZCBhZGRpdGlvbmFsbHkgYmUgZXhwb3NlZCB0aHJvdWdoIGEgY2F0YWxvZw0KPiA+IHRh YmxlIG9yIFNRTCBmdW5jdGlvbiwgaWYgdGhhdCB3ZXJlIGRlZW1lZCB1c2VmdWwuKSBUaGlzIHdv dWxkIGxldCBhDQo+ID4gREJBIG1vcmUgZWFzaWx5IGF1ZGl0IHVzZXIgYWN0aXZpdHkgd2hlbiB1 c2luZyBtb3JlIGNvbXBsaWNhdGVkDQo+ID4gcGdfaWRlbnQgc2V0dXBzLg0KPiANCj4gVGhpcyBz ZWVtcyBsaWtlIGl0IHdvdWxkIGJlIGdvb2QgdG8gaW5jbHVkZSB0aGUgQ1NWIGZvcm1hdCBsb2cg ZmlsZXMNCj4gYWxzby4NCg0KQWdyZWVkIGluIHByaW5jaXBsZS4uLiBJcyB0aGUgQ1NWIGZvcm1h dCBjb25maWd1cmFibGU/IEZvcmNpbmcgaXQgaW50bw0KQ1NWIGxvZ3MgYnkgZGVmYXVsdCBzZWVt cyBsaWtlIGl0J2QgYmUgYSBoYXJkIHNlbGwsIGVzcGVjaWFsbHkgZm9yDQpwZW9wbGUgbm90IHVz aW5nIHBnX2lkZW50Lg0KDQo+IEZvciBzb21lIGF1dGggbWV0aG9kcywgZWc6IEdTUywgd2UndmUg cmVjZW50bHkgYWRkZWQgaW5mb3JtYXRpb24gaW50bw0KPiB0aGUgYXV0aGVudGljYXRpb24gbWV0 aG9kIHdoaWNoIGxvZ3Mgd2hhdCB0aGUgYXV0aGVudGljYXRlZCBpZGVudGl0eQ0KPiB3YXMuICBU aGUgYWR2YW50YWdlIHdpdGggdGhhdCBhcHByb2FjaCBpcyB0aGF0IGl0IGF2b2lkcyBibG9hdGlu ZyB0aGUNCj4gbG9nIGJ5IG9ubHkgbG9nZ2luZyB0aGF0IGluZm9ybWF0aW9uIG9uY2UgdXBvbiBj b25uZWN0aW9uIHJhdGhlciB0aGFuDQo+IG9uIGV2ZXJ5IGxvZyBsaW5lLi4uICBJIHdvbmRlciBp ZiB3ZSBzaG91bGQgYmUgZm9jdXNpbmcgb24gYSBzaW1pbGFyDQo+IGFwcHJvYWNoIGZvciBvdGhl ciBwZ19pZGVudC5jb25mIHVzZS1jYXNlcyBpbnN0ZWFkIG9mIGhhdmluZyBpdCB2aWENCj4gbG9n X2xpbmVfcHJlZml4LCBhcyB0aGUgbGF0dGVyIG1lYW5zIHdlJ2QgYmUgbG9nZ2luZyB0aGUgc2Ft ZSB2YWx1ZSBvdmVyDQo+IGFuZCBvdmVyIGFnYWluIG9uIGV2ZXJ5IGxvZyBsaW5lLg0KDQpBcyBs b25nIGFzIHRoZSBpZGVudGl0eSBjYW4gYmUgZWFzaWx5IGxvZ2dlZCBhbmQgcmV2aWV3ZWQgYnkg REJBcywgSSdtDQpoYXBweS4NCg0KLS1KYWNvYg0K