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 1lJPif-0004Jt-Ry for pgsql-hackers@arkaria.postgresql.org; Mon, 08 Mar 2021 23:55:26 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lJPie-0006AU-Pr for pgsql-hackers@arkaria.postgresql.org; Mon, 08 Mar 2021 23:55:24 +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 1lJPie-0006AL-7E for pgsql-hackers@lists.postgresql.org; Mon, 08 Mar 2021 23:55:24 +0000 Received: from mail-co1nam11on2079.outbound.protection.outlook.com ([40.107.220.79] helo=NAM11-CO1-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 1lJPib-0002GE-QF for pgsql-hackers@postgresql.org; Mon, 08 Mar 2021 23:55:23 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=lL5PbDMNVPQfRkG28TMKj/7PUNAB70Sm/XkisVKKDTtsnjjIMaJ2yaKKhhgGq0vZWBXs/OuYwdvHMuAwTudPuTcHYwzIlPWGU9M3XvbcsgMwVAxqo0Dz4hoSFlud2CFsNuGePhzj9HdIgd24UOR1mc4gzH36MJoMcA5fGuoSyJez6MbwpayNYZTTzG1c99Cx1LK7eVUtofDFYGTCpUHWKnMLCWqu4s/oZCzN92EtVNussiSfen9F5axrn6qtl8csgcycMCpSXRppuA6BJu4fbLYhGoC+Eyf9XAgrkzVeYAwvjb5/tMug2trOVI1Jq69WF4e0PkDG0yEkxohnAPcJBw== 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=7A1TvgLFMdbbzxNBAFZ7As+u6y1Iavo9ucWSengELpk=; b=Pi7wicVgYnv0RlWc+yJc+NeLd1pMCzScHLdz/1d8Mji2S7g5gZ6ZINykryMexibifY+rpnbQpFjibxUtJVH+kfw95wnC/LNrtVdmxE3YNzma60N7RbG2S0oxuHTP0DF3pdS42os2JUDrcViaTQz4fiUiAoLhOo9Cznhvc5b12UIrkgt3N7sQ6jJxL4Dyu5dZabKNZKnOmMMbjEySxLPBYGj6Hc1mM9Lk60SmsT49pnC6dAPfef1CsnKr4YekGXg4oPhZsmkbNxJDP4ZaF0d8I8Z41GpDNp2kx6aVpZH3sC0tW767zGgi1XZ6natTDf4wFFhoenRXm8p01Aik7vcrAg== 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=7A1TvgLFMdbbzxNBAFZ7As+u6y1Iavo9ucWSengELpk=; b=YxrUz3ZH1k4WaNlyDjpNSl3wjA/hxndJEpXJlbhwapyG5fh2jpq3ifKBcNO4XdrKZgjrV13Buk7HogehDLN3h6mK/AZMtPqlN1KhiflfJTBymbsZfT0cxh+OxWOtQhbBK6tTQqtHUEfxovgLiQbySkN2PZS7EOnZz/oINkqTNz0= Received: from MWHPR05MB2896.namprd05.prod.outlook.com (2603:10b6:300:65::20) by MWHPR05MB3469.namprd05.prod.outlook.com (2603:10b6:301:43::20) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.3912.9; Mon, 8 Mar 2021 23:55:16 +0000 Received: from MWHPR05MB2896.namprd05.prod.outlook.com ([fe80::cc46:e1a9:6424:c456]) by MWHPR05MB2896.namprd05.prod.outlook.com ([fe80::cc46:e1a9:6424:c456%12]) with mapi id 15.20.3933.025; Mon, 8 Mar 2021 23:55:16 +0000 From: Jacob Champion To: "magnus@hagander.net" CC: "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/fl6pFeJoAgAmCVACABIPmgIAXhdMAgAxttwCAA3O0AIAAG6GA Date: Mon, 8 Mar 2021 23:55:16 +0000 Message-ID: <49b2d3032f96226d2c82b370ecf6026147aeca2d.camel@vmware.com> References: <5d8b74e64fe4a610b23624277e497cc0a925db4b.camel@vmware.com> <2870147caa759155c5c8a232bbd2399f41f76491.camel@vmware.com> <4b2ca51542fa84e6fa37ab678624d5b400c092c0.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: 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: 469df45e-34d5-4b28-8404-08d8e28d9f81 x-ms-traffictypediagnostic: MWHPR05MB3469: 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: jG6/bqM9JIVbgekbqMAaYUu+w5/Ct7tE8QUMtiqeVKMdkajUsz0PNBjq29rYcwYmao5omidSmiucCgIToyEfU9JDgTQV0CF4x2ZZgn/37vUkZJpLvJ09MYQzUMqlwCHD0aG7sAX/tp27Bj/VV3MOAAlWAXWAgJd7p55+tdt2JW83zd0xmcLLRJpAmEfgXFYBmBbd6ItnIgltwq1MtbGLLfQlm67ghLcVYI3hMeUQIV4YMLT/2fby0MNYHKiNoxPOp0HbPSYD5psLBcYzxjtUYdADuGmpfeydD7TZE53dcGxE8YAt2V6d9M9vy3qjEXG5J0U6SBvgpVtSQJ86C6NVauJZz1/j5l2kO48R/FHY60WSgA/58akSPbApazCeHTP14zdhsYLJQhD5WCQE86m8ruu4uoPLrJUIuKw5jmBvD6mx3xyZ4iAKFrUGi6hMCn023R5Ypy6s/Zgqy8tKrzMrP2cHk5TVSeZ7V3QmkQ3h0CPk78t+1KkxwSEqJSXrn67gy+SOYYA73TRX+NYwoYpvRw== 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)(366004)(396003)(39860400002)(376002)(136003)(346002)(186003)(26005)(83380400001)(2616005)(36756003)(2906002)(6486002)(66946007)(6916009)(66446008)(5660300002)(66476007)(86362001)(316002)(64756008)(6506007)(4326008)(6512007)(8676002)(76116006)(478600001)(71200400001)(8936002)(54906003)(66556008);DIR:OUT;SFP:1101; x-ms-exchange-antispam-messagedata: =?utf-8?B?ZWpxSEExc21kZXJGNFpwREpZNVUvcFZuVFludllpcWtSdHRGK2ZEY3A3M2F5?= =?utf-8?B?bVk2VEVxa05zYWZpd2FyanRGWk5EM2RUU2RsYVFSaHR5Y1dKbWZZcXR1ZCsx?= =?utf-8?B?elZ5eG93M1hkQlhDNGpkMmh0SWFzMzlOVmlZWmtROGdMaDBCa1VvaXVxK21K?= =?utf-8?B?Rk11M044dWhQdHI5cVNQM0pwMTVUbSswc0k2MmNkUVZpbGFQRU1OWlFMbmw4?= =?utf-8?B?UDNDdWlrNkZ6TTJrME80MzB1Tk1VMHFuTitkYlV6alp4ZVI5YXZYMHYwa0Ru?= =?utf-8?B?R0pmV3BPb2ZDKzl3ZlVWdFk0S29CMUxiOWdBdCtPOUFVZzBVZ1F2Y0xSYUtJ?= =?utf-8?B?RXUxYW91L0s2QWEvMkFKbTBaOC9LMHBqMjdVN2EwQmJrdzlVZUdVZ1BiNmZ5?= =?utf-8?B?SXVNdGVHamR3KzBTSW9oV3pGZ3pEMkpUK2dUK2dYMkdjQ3ZxbjNoSFJIVDMw?= =?utf-8?B?VkR6bEsyV0xTT3crekx4alQwM1pINTI0Nmx2ekxXVmtYUmF0YjZKYWx4VXdk?= =?utf-8?B?QWROb2piNlFuZ1BNYWtnL3hBc1lCSGZnL25UUWN3cHpFVGpieCs0RnhDMGtB?= =?utf-8?B?RlB1azd2VmpoczVVc1dPbVI3dEg1Tk51QlFmMnY1dE00MzFwNWpnWmw5MjJJ?= =?utf-8?B?eVE5WlA2em9hM1JZOUx6WENiN1h5Q2tXbVlpTHJWUTEvQ3BCSjQ5d1BDbXRK?= =?utf-8?B?d1FQK0pUOUtPZmxlTVBTVEVmRHV0TUp0SmF1alZKRWpVNjQ5Z01Vb1JaYnpD?= =?utf-8?B?dEczaEFJRDRvRGxqanliak15enJoYmE4V1c0bFZhc0piKzd0SS9BdU9WR1RQ?= =?utf-8?B?MXdqTmo3OGVEVnVRQzBEeVgwcENyY3BhVkFxL0hRbS92QnMwK2p2TzBoWFNy?= =?utf-8?B?Q3NWcm5VNDZGRW9SRE5DOWZyLzd5OW55Z3MrWVpUMTV4RG5nTHUwOG1lcGlw?= =?utf-8?B?azY2VFVPQ25vTXhBT1BKZDR0VmhienA5dXQ3c2JPbVhJYko1OTV3U3RKd3JQ?= =?utf-8?B?aTlIR25wU2xUR1FYbDkwWGlIKy8wdmtMaFArYWE3Q1krOGZPQTFaMHByZktQ?= =?utf-8?B?VG9NV2JzdHFObk54NjFCYzkwendpdDQ0Zk44N1JkNy9TbE1pVktiRVVwY2R0?= =?utf-8?B?REk1UW1WMS9oL00zYlplQURERStreEpXYU9TcTlWVWlRN1dKRmkxcVBaUW1P?= =?utf-8?B?ZnN3a045ZzVTZDhlMlB0aXE4WGtON05MQXBwY0VibUJmeTlVTjBHVjAvam9J?= =?utf-8?B?T1NNUmswSXkyZVFjc0VWZzJsSU8vcWl0UmRJMkFqeWJSSjVsYkhTeDR0L2NU?= =?utf-8?B?Rk1rc0lSdHVTRzhuNzFQZGlBRmNYc0lvRWR3YkI5MkpndFEzL2QxNFRvR3Js?= =?utf-8?B?NUREQUM5TEMwYzFiZmFtaCthU0hoT0NmTWI0YmJxQ1RBVGtHcmE2WHQyaDhF?= =?utf-8?B?UmpJc2xMQjdJdkljaE9kdmZod3l3cWJibTJ4ZXJNSHNza0FiR3kxMnNjSFdC?= =?utf-8?B?Y0RVMGlacHQ5am0wblJPcUMyTExOdGN0dk5ZYXpFSkp1VnlxdCtiKzVvRjYz?= =?utf-8?B?Nk00NGdNVnJUbFNhQS9PY0VRckN4RENPemdSL0xJaC83NkRyOGhaMGFTU2RQ?= =?utf-8?B?OUlLWmNtdEhxWmplMW4xL096YmJ4TkhWeHpNU2J6a2FQRnJ0T2JiWnB4aDR3?= =?utf-8?B?U3kzTXFsR1dsdVIybGN4enUyWXpXT3dhQVVNYVdOTEhBRVNNSGVRZ1J6ZFFv?= =?utf-8?Q?Xf6NJdvmJhPh3i9vcB9c0ehJDlFFeyNOlFwpG/u?= x-ms-exchange-transport-forked: True Content-Type: text/plain; charset="utf-8" Content-ID: <2B354E14619982448A0F83AC7271D4D2@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: 469df45e-34d5-4b28-8404-08d8e28d9f81 X-MS-Exchange-CrossTenant-originalarrivaltime: 08 Mar 2021 23:55:16.6626 (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: zra0v6wQf9XDhPPWcVeoD0CtY2v9QL/+vO/Rre/HyNeDH3oEPmTVsGJIgOghuvrdRZtj7HhSwd3XDUPm2FbitQ== X-MS-Exchange-Transport-CrossTenantHeadersStamped: MWHPR05MB3469 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk T24gTW9uLCAyMDIxLTAzLTA4IGF0IDIyOjE2ICswMDAwLCBKYWNvYiBDaGFtcGlvbiB3cm90ZToN Cj4gT24gU2F0LCAyMDIxLTAzLTA2IGF0IDE4OjMzICswMTAwLCBNYWdudXMgSGFnYW5kZXIgd3Jv dGU6DQo+ID4gV2l0aCB0aGlzIHdlIHN0b3JlIHRoZSBzYW1lIHZhbHVlIGFzIHRoZSBhdXRobiBh bmQgYXMNCj4gPiBwb3J0LT5nc3MtPnByaW5jLCBhbmQgQUZBSUNUIGl0J3Mgb25seSB1c2VkIG9u Y2UuIFNlZW1zIHdlIGNvdWxkIGp1c3QNCj4gPiB1c2UgdGhlIG5ldyBmaWVsZCBmb3IgdGhlIGdz c2FwaSB1c2FnZSBhcyB3ZWxsPyBFc3BlY2lhbGx5IHNpbmNlIHRoYXQNCj4gPiB1c2FnZSBvbmx5 IHNlZW1zIHRvIGJlIHRoZXJlIGluIG9yZGVyIHRvIGRvIHRoZSBnc3NhcGkgc3BlY2lmaWMNCj4g PiBsb2dnaW5nIG9mLCB3ZWxsLCB0aGUgc2FtZSB0aGluZy4NCj4gPiANCj4gPiBbLi4uXQ0KPiAN Cj4gU2VlbXMgcmVhc29uYWJsZTsgSSdsbCBjb25zb2xpZGF0ZSB0aGVtLg0KDQpBIHNsaWdodCBo aXRjaCBpbiB0aGUgcGxhbiwgZm9yIHRoZSBHU1Mgc2lkZS4uLiBwb3J0LT5nc3MtPnByaW5jIGlz DQpleHBvc2VkIGJ5IHBnX3N0YXRfZ3NzYXBpLiBJIGNhbiBzd2l0Y2ggdGhpcyB0byB1c2UgcG9y dC0+YXV0aG5faWQNCmVhc2lseSBlbm91Z2guDQoNCkJ1dCBpdCBzZWVtcyBsaWtlIHRoZSBleGlz dGVuY2Ugb2YgYSB1c2VyIHByaW5jaXBhbCBmb3IgdGhlIGNvbm5lY3Rpb24NCmlzIGluZGVwZW5k ZW50IG9mIHdoZXRoZXIgb3Igbm90IHlvdSdyZSB1c2luZyB0aGF0IHByaW5jaXBhbCBhcyB5b3Vy DQppZGVudGl0eS4gRm9yIGV4YW1wbGUsIHlvdSBtaWdodCBjb25uZWN0IHZpYSBhICJob3N0Z3Nz ZW5jIC4uLiB0cnVzdCINCmxpbmUgaW4gdGhlIEhCQS4gKFRoaXMgd291bGQgYmUgYW5hbG9nb3Vz IHRvIHByZXNlbnRpbmcgYSB1c2VyDQpjZXJ0aWZpY2F0ZSBvdmVyIFRMUyBidXQgbm90IHVzaW5n IGl0IHRvIGF1dGhlbnRpY2F0ZSB0byB0aGUgZGF0YWJhc2UuKQ0KSSdkIGFyZ3VlIHRoYXQgdGhl IHByaW5jaXBhbCBzaG91bGQgYmUgYXZhaWxhYmxlIHRocm91Z2ggdGhlIHN0YXRzIHZpZXcNCmlu IHRoaXMgY2FzZSBhcyB3ZWxsLCBqdXN0IGxpa2UgeW91IGNhbiBzZWUgYSBjbGllbnQgRE4gaW4g cGdfc3RhdF9zc2wNCmV2ZW4gaWYgeW91J3JlIHVzaW5nIHRydXN0IGF1dGguDQoNClRoZSBzZXJ2 ZXIgZG9lc24ndCBjdXJyZW50bHkgc3VwcG9ydCB0aGF0IC0tIGdzcy0+cHJpbmMgaXMgb25seQ0K cG9wdWxhdGVkIGluIHRoZSBnc3MgYXV0aCBjYXNlLCBhcyBmYXIgYXMgSSBjYW4gdGVsbCAtLSBi dXQgaWYgSSByZW1vdmUNCmdzcy0+cHJpbmMgZW50aXJlbHksIHRoZW4gaXQnbGwgYmUgdGhhdCBt dWNoIG1vcmUgd29yayBmb3Igc29tZW9uZSB3aG8NCndhbnRzIHRvIGV4cG9zZSB0aGF0IGluZm8g bGF0ZXIuIEkgdGhpbmsgaXQgc2hvdWxkIHJlbWFpbiBpbmRlcGVuZGVudC4NCg0KVGhvdWdodHM/ DQoNCi0tSmFjb2INCg==