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 1l5dGI-0005FG-Sa for pgsql-hackers@arkaria.postgresql.org; Fri, 29 Jan 2021 23:33:11 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1l5dGG-0002bK-Cf for pgsql-hackers@arkaria.postgresql.org; Fri, 29 Jan 2021 23:33:08 +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 1l5dGG-0002bD-15 for pgsql-hackers@lists.postgresql.org; Fri, 29 Jan 2021 23:33:08 +0000 Received: from mail-eopbgr770040.outbound.protection.outlook.com ([40.107.77.40] helo=NAM02-SN1-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 1l5dGD-0001f8-6W for pgsql-hackers@postgresql.org; Fri, 29 Jan 2021 23:33:06 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=BP2ovMrLYNkLGc28cxMCXHsJIDvgbJ5grnGWZ+aEDbCSoAOLuv5qzm/bUitnpD39GWFXxpxVQbvF+uw3bLOeR6WIVKaLU0F0r3NLLMuOLDqW+Mr4eF3k3f5W13U/6h8ZlJG6FrZoWAC4HQkW8WlF06EGYR9LanQjg0uapXfEoBGSaozMNeEOKLFfm1krfSygopbus8zPxUhPRvRcDtxaKd3OtDGsKxMul08M8LVsKLRsBpiV8yAhf0Nu6nAeCIPaVUKIZCdRbV4MgRCZ5qyFZ8e3cWxGipY5JAyV9604e0l8f3YkzRNuNqWLa2/voJqvCwF/tnUzTUSdiSHba5dO+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=GO10bFOjsDkJ/zt405BWuQSIpS+yCj8ZKSvyv9lILmc=; b=DpfEbuaR9b/RphJsIO9z91edarr4NRdnW7BcFw141R9Azt+q5kEw9gPw5rBs6MAff1zb2zaKVU+fXpaFYY8Uij13WJ6MLlMYik82uKwTdVlVJSH/ukgbRm0cMVpQdtwnSgqVvU6phL3eXAlcGaB3fnwG3W5OxIUaWIQSjB55sm0MmpGjt2d31TF8rLSDCsnacyigntwuiVMz+cca3Mpw3S9dCrtP7LPY2lcfLoNwQD4opxr1jEdymhePqoh8/5NfOm+snniK2GwP9UnitrdzJkEI4bL5PJhK4QYaV4poOs9QyxHTCEOyyJJ1JUO/8geR93lB95sxE7FWnpV5QthyZg== 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=GO10bFOjsDkJ/zt405BWuQSIpS+yCj8ZKSvyv9lILmc=; b=1PhRCtEwNZA2SRAbUI2NkymdvW2s7S3WGwKd4EEsJRzUZ1v4NRvHabNBtU8w8mC4mgnuVFY4DYFDrffvuCwArBerHJ4eVV7YLvjwrUchRN3BOJkJ2CTRX4tYM+BxE5DiOnKQPF+RlaSK24TF49fLVy/EYf8k/WlL/JSv2sQPwE4= Received: from (2603:10b6:300:65::20) by CO1PR05MB8103.namprd05.prod.outlook.com (2603:10b6:303:f1::16) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.3825.10; Fri, 29 Jan 2021 23:33:02 +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:33:02 +0000 From: Jacob Champion To: "tgl@sss.pgh.pa.us" , "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/KTGAgAAISwCAABFqAA== Date: Fri, 29 Jan 2021 23:33:02 +0000 Message-ID: References: <20210129220101.GE27507@tamriel.snowman.net> <2829030.1611959442@sss.pgh.pa.us> In-Reply-To: <2829030.1611959442@sss.pgh.pa.us> 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: sss.pgh.pa.us; dkim=none (message not signed) header.d=none;sss.pgh.pa.us; 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: 6b05d342-52e5-4524-c9ac-08d8c4ae38c9 x-ms-traffictypediagnostic: CO1PR05MB8103: 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: iL7Dr+SDzNIzo88cbd9ql633fdF9UTZ+Wq7+gyt77pT4iT4naCvZ20IaJYKeOelANNbH/4MvW0gcn7h1BLdAv4ILTw9/juERxJy7K901JStpyr0psp08XD0d8BDzJvaMaUP/FgnU7EryhHTCpj2/A3DeLE+sMuKRWZDuR6wJ7fByu6DWiAGim5+QyuA6BYIAZE6+0UD6fvtQJ0KJPuy3sEQQdTL6h8V2dmX76gEwb+qo+I6GGOK+9b6+b7zJZiyCozFYehzw72HzoOq8LdtK6K8sZ2JrBKj//2KuA7J0pKGdI7xYbQ+Rm1D3ZxlHQ5R/4Fii9mKonjjHcjwsNbkmg6BHPad05GakoVXOz3hHRFy5p1PRNmJfUYdtt/FcNPycGNTX7w0CWZnQpcJcvIhtfxyqcQfhhKyvGuZv4GTwMM5MwrEehBOTWQjTJqde1+tmgPpgeMt5JT5wYy1KK94JNX9de9Rw47itTqezH9sjgR4fz12OyK4DSgzJ4B5Z+UykZn41J1qAb3s56zbZgJbCuQ== 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)(39860400002)(396003)(366004)(376002)(478600001)(64756008)(66446008)(66556008)(66476007)(76116006)(66946007)(5660300002)(2906002)(26005)(8676002)(186003)(6506007)(4326008)(86362001)(8936002)(6486002)(83380400001)(316002)(2616005)(71200400001)(6512007)(110136005)(36756003);DIR:OUT;SFP:1101; x-ms-exchange-antispam-messagedata: =?utf-8?B?SlRwTzVOcEtJeUhuY0tmVkVuNUJVeTJHMXNOUXQzVXdxTTBxOWpaK3VRZFJr?= =?utf-8?B?K0ptd1d1cjJnank1NHhqUGRxcy9RMTZzcmhoa2oraUNCTW4vWjhQOWRZRHNi?= =?utf-8?B?dCtOaHEveEdxVTBlMHFjejBjdUQyVVBoa3ovRzc0WEpnWkZzUlZ5VXBQMWht?= =?utf-8?B?TVgvRVYyZzM1MXJjN1hJWFA0YzY5YUQ3YjJyUGg4TEV4Sk1vNUp2ZXFIcnRX?= =?utf-8?B?bTBua1FEKzNkMXlYS3kyL2FjU0Q3SFhybTJHQ1RTU1R5K2hCekJlTjIwVHBk?= =?utf-8?B?b3BXcFNHOWdUd29CNjhrNjNQOHA3YXRNclNybVo3UW45TGNWZDRxVWszd1Qw?= =?utf-8?B?WlRRR1ZNeDZHSFgrQnFPZ0xCczJDVitGa3ZWVUFrVHk5b1dXb2lzcTd0ZnpY?= =?utf-8?B?UjNlM0J0eG5ZTTRzWlN3MFNVdmhMZ3dqbHlHc1ZBM2x1VStoWnFWMExBT1VK?= =?utf-8?B?eU82azJKUjBpeGd6c2tnTHJrdTZWMG0xdGFWa3Flbk1RU0NLSUk5eDBpbjZn?= =?utf-8?B?M1FNNWoyRXNReFVyYXZ2Wmh0Kzl3azV4OVZGOTI0eTkzSVpPV1gwNjBOVVJu?= =?utf-8?B?MitFR1A1UDNxUExMclErby9jeW1WNFFpS2VUdE15OC9rc2taRVZrS2lZUjNV?= =?utf-8?B?VXpJREIzOFdTUEhBTWdNejB0YXNLNTJLaEVzK21ZMnZpTEt6QWUxL09ScVlm?= =?utf-8?B?OHU4WUQycFI4aWZTSlNCa3lOeFVGY0VpTytFdmZMdDBaSjVINzRNcFhieGwy?= =?utf-8?B?clpMa0wxS3lSMDVPaFBUbUg3Z3hCelVreXl1MzNpSEU3VVYxRlgrWHlmb0NV?= =?utf-8?B?VDJvbGhMMWtMaHYxQ0d4T1l0MFI1YlpUTDBTU3pJUWcvVlNLOVZuSGJORTB6?= =?utf-8?B?MTdVSXo3TWFWN2dDVmNnbnBxUlFPMFpIdmpFWld1ZytsOHNMbS9Od0FOWEV5?= =?utf-8?B?ZWZlVml3VkpuL1dWOGFrZTV0NUpMbHpucENqVjVPd0I0Qk9JL0NFamluRjJw?= =?utf-8?B?dUhNQW9rcDRvY2hoRUh0M1FUTktVY2h0WXFaRXZFemJCZjg1VEgweDNJUXM4?= =?utf-8?B?STgwc3MrUkwvbEtCRjVxbFZDbTMrQjFUVkFGRUI1OUJLT29XMGlLUU9NU2Z4?= =?utf-8?B?RmdBQnFINUJxTHRRR3RvQTB4dnEwaWJWRnVKTlJReGtqVmtxNlA0MGQyNUlE?= =?utf-8?B?SDg1TFhiajFTZEVMWTVZY2VJeVE0VHNtNlRRd25WdmlDU2wrUVMycXZMNnVi?= =?utf-8?B?SlVLVVYweTRJZ2FzcUp1bFdBcEFlMlY3Mm1hdnNQYW0xYzZ0ZEVIMTg2MnpS?= =?utf-8?B?aHovTFRCM2RnK2FBUHVYRllaOTNiL3BrTitJM25HWGxEU2QxR296QTY1YVJr?= =?utf-8?B?cjNPLzNkVUlkYlZyczN5MHV6c1NJOGpYQllIRzJGbHhBNEVoOUlGUVB1Y2NZ?= =?utf-8?B?dUdJTk13azB3NFpUSldHVHV3SHJnZ2lXS1MxTHlnPT0=?= x-ms-exchange-transport-forked: True Content-Type: text/plain; charset="utf-8" Content-ID: <8ADF328F6CC2744E96C2FF72529E43A9@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: 6b05d342-52e5-4524-c9ac-08d8c4ae38c9 X-MS-Exchange-CrossTenant-originalarrivaltime: 29 Jan 2021 23:33:02.7697 (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: a5PaxGifaf8G1N/bhk8YXRcWKN8S52Ol060EGx49AmKSGpL23kSWjJaJykUJHjrF9WVeO1sKfeFzYWSqddnyCw== X-MS-Exchange-Transport-CrossTenantHeadersStamped: CO1PR05MB8103 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk T24gRnJpLCAyMDIxLTAxLTI5IGF0IDE3OjMwIC0wNTAwLCBUb20gTGFuZSB3cm90ZToNCj4gV2hh dCBoYXBwZW5zIGlmIEFMVEVSIFVTRVIgUkVOQU1FIGlzIGRvbmUgd2hpbGUgdGhlIHNlc3Npb24g aXMgc3RpbGwNCj4gYWxpdmU/DQoNCklNTyB0aGUgYXV0aGVudGljYXRlZCBpZGVudGl0eSBzaG91 bGQgYmUgd3JpdGUtb25jZS4gRXNwZWNpYWxseSBzaW5jZQ0Kb25lIG9mIG15IGdvYWxzIGlzIHRv IGhhdmUgZ3JlYXRlciBhdWRpdGFiaWxpdHkgaW50byBldmVudHMgYXMgdGhleSd2ZQ0KYWN0dWFs bHkgaGFwcGVuZWQuIFNvIEFMVEVSIFVTRVIgUkVOQU1FIHNob3VsZCBoYXZlIG5vIGVmZmVjdC4N Cg0KVGhpcyBhbHNvIGRvZXNuJ3QgcmVhbGx5IGFmZmVjdCB0aGlyZC1wYXJ0eSBhdXRoIG1ldGhv ZHMuIElmIEknbSBib3VuZA0KYXMgcGNoYW1waW9uQEVYQU1QTEUuQ09NIGFuZCBhIHN1cGVydXNl ciBjaGFuZ2VzIG15IHVzZXJuYW1lIHRvIHRsYW5lLA0KeW91IF9kZWZpbml0ZWx5XyBkb24ndCB3 YW50IHRvIHNlZSBteSBhdXRoZW50aWNhdGVkIGlkZW50aXR5IGNoYW5nZSB0byANCnRsYW5lQEVY QU1QTEUuQ09NLiBUaGF0J3Mgbm90IHdobyBJIGFtLg0KDQpTbyB0aGUgcG90ZW50aWFsIGNvbmZ1 c2lvbiB3b3VsZCBjb21lIGludG8gcGxheSB3aXRoIGZpcnN0LXBhcnR5IGF1dGhuLg0KRnJvbSBh biBhdWRpdCBwZXJzcGVjdGl2ZSwgSSB0aGluayBpdCdzIHdvcnRoIGl0LiBJIGRpZCBhdXRoZW50 aWNhdGUgYXMNCnBjaGFtcGlvbiwgbm90IHRsYW5lLg0KDQo+IE1vcmUgZ2VuZXJhbGx5LCBleHBv c2luZyB0aGlzIGluIGxvZ19saW5lX3ByZWZpeCBzZWVtcyBsaWtlIGFuIGF3ZnVsbHkNCj4gbmFy cm93LW1pbmRlZCB2aWV3IG9mIHdoYXQgcGVvcGxlIHdpbGwgd2FudCBpdCBmb3IuICBJJ2QgcGVy c29uYWxseQ0KPiB0aGluayBwZ19zdGF0X2FjdGl2aXR5IGEgYmV0dGVyIHBsYWNlIHRvIGxvb2ss IGZvciBleGFtcGxlLg0KPiBbLi4uXQ0KPiBZZWFoLCB0aGlzIHNlZW1zIGxpa2UgYWJvdXQgdGhl IG1vc3QgZXhwZW5zaXZlIHdheSB0aGF0IHdlIGNvdWxkIHBvc3NpYmx5DQo+IGNob29zZSB0byBt YWtlIHRoZSBpbmZvIGF2YWlsYWJsZS4NCg0KSSdtIGhhcHB5IGFzIGxvbmcgYXMgaXQncyBfc29t ZXdoZXJlXy4gOkQgSXQncyByZWxhdGl2ZWx5IGVhc3kgdG8NCmV4cG9zZSBhIHNpbmdsZSBsb2Nh dGlvbiB0aHJvdWdoIG11bHRpcGxlIGF2ZW51ZXMsIGJ1dCBjdXJyZW50bHkgdGhlcmUNCmlzIG5v IHNpbmdsZSBsb2NhdGlvbi4NCg0KLS1KYWNvYg0K