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 1l744a-0007lX-1T for pgsql-hackers@arkaria.postgresql.org; Tue, 02 Feb 2021 22:23:00 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1l744Y-0000bp-Pb for pgsql-hackers@arkaria.postgresql.org; Tue, 02 Feb 2021 22:22:58 +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 1l744Y-0000bi-8u for pgsql-hackers@lists.postgresql.org; Tue, 02 Feb 2021 22:22:58 +0000 Received: from mail-co1nam11on2062.outbound.protection.outlook.com ([40.107.220.62] helo=NAM11-CO1-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 1l744T-00056p-Py for pgsql-hackers@postgresql.org; Tue, 02 Feb 2021 22:22:57 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=FSEkZ3Z/bXDEVRbILbzfUY2mrYxLBmf5fuTZqEyuBUECpmqO6/Swb0ObMnTPxrArmFkE3MV3s9bSHbe+l/CIkH69FcjZugn/jn3yb4VajIWN95OGgKZRScBq5eRwofQX+lxw6KL58ykZb8KxFAIoUIi/8rX/V2YeMpimbyJhg68VmOLqK9LRAUTdk3YOvyCrJhmlTQt0j13aIQVveeVXGadAgZajq4q1txf8HThm8tevMegRcp1tFPvg8aC33AvHd8/6kfuQ69XnS4Hnc0aZecOhtufOzi13BV97BsUfxwua+BEtfLAN5ABW/i6aXqA1/B797bdDMRtAA7ZQ05VzBg== 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=Swtk1s8RufeaEgGTzlBk97Yk1JhMZYbEaHf1L2d/KXc=; b=LN2CX4X1V1YKezebiNZoCLIYJwZ/eFRxoGd9oDo8BQZZuUtzjD5U+MkdHgklb+x4rZuQBBwkKzmg8Sq1wiDQD+OXzVuE6PzF1G7RbJ67A2DIYxFRjCfVg4HYGMG9PSaL33D1pNQea4l8VyLRs5XiK5Wh9lmxSBzn6LEKFGWAyBQJEDQ60jKdWeq54QWu2zcKmGWTMrgMoS0QlshQ1ivSwg6YZOuVVq9zwwkLTObUPmqDBsRxOAZaqCxSL/XeJx3nhCRhnf/I3nB+4386UbtZFmomZG4TnOXro2ZO1WFgpuwpCfNIzcfHsD6/u9auh6273Rxdw8pFe4j/1Rqi8V76Ew== 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=Swtk1s8RufeaEgGTzlBk97Yk1JhMZYbEaHf1L2d/KXc=; b=HNjA49CqcGXb8dZyFeZb1pnZjfwIlj6GZE7hKlz+HTSC90MdfWOeJsytmFnjGo5Gsr5GkdwoJq8kE8nYw90uRRmldEVXk4+yNeYiN/K/4MEkZzBUDWUZXKvAIJZiY1cFOgfrMcnFByCoxyqwa8HXtnzdHAiIHSElC30kHkoaf2s= Received: from (2603:10b6:300:65::20) by CO6PR05MB7620.namprd05.prod.outlook.com (2603:10b6:5:353::12) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.3825.8; Tue, 2 Feb 2021 22:22:49 +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; Tue, 2 Feb 2021 22:22:49 +0000 From: Jacob Champion To: "pgsql-hackers@postgresql.org" CC: "stark@mit.edu" , "magnus@hagander.net" , "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/fl6pFeJoA Date: Tue, 2 Feb 2021 22:22:49 +0000 Message-ID: References: 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: postgresql.org; dkim=none (message not signed) header.d=none;postgresql.org; 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: 35df0c4b-c391-4027-570d-08d8c7c9133b x-ms-traffictypediagnostic: CO6PR05MB7620: 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: ZG2o1JpiT7Zde+UBijy5+MZzdUcN6n01cdjj59zrkBBSKa8eD3ZYSQSKCr2yXZ8AYr4nYyZGjmdaG4fCQ3uB4yOWpCKd3bisS0bOeL9S5rg5iZKTFUTQlGXbC8jse8vXpYVKoKo1RrSnGjKcG+2JNGyQOLr26Amsqyzwjv996YSKUpqIRBNHs85TDdyqlYz9FD36Vqt2doRgHqoKYnvNek67A3+iLdU4azAXr/CPXXs5ZNd6Xm7hcAHsPKwLQqJaU+/dCtLpHhNF+9V21PuZGZHQ+GoJigiD+Q2pC/ZLn6ZfDRZQ67YAUDZphmfuLZXwYijpIabAxlO+4ao/T+r1PovwSuyv6Mtj6tYgg+HssfuYQeT7M2D94cPJTes4vY5/c+qu1ZFXLXVzZJRVT6yfWnJ6SpLGeoAm3muXznAd6hA5QTR9MlrNtxoSmNeab3tHkZZ5lH9EwWdQir2oTVz0L559qDHNT4x3S2dofbm2/ITNCK6al07o/9aRVz9gCssgWi1TX6UUtxZ6duhYfzl8qA== 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)(39860400002)(136003)(376002)(396003)(366004)(66946007)(86362001)(8676002)(71200400001)(36756003)(76116006)(26005)(2616005)(66446008)(6916009)(5660300002)(316002)(8936002)(64756008)(66556008)(6506007)(54906003)(6512007)(186003)(83380400001)(66476007)(478600001)(6486002)(2906002)(4326008);DIR:OUT;SFP:1101; x-ms-exchange-antispam-messagedata: =?utf-8?B?aHl4QnJNS1RjQnpJMDhoQTNpZjhwaGwyVDFmVnZKc3VZVG9KRDE1UVdkSC9o?= =?utf-8?B?ZFVpSEpjZEV5ajJMeUtQak5LYk4rNlhTWklYdlFzcnZvK1VWUTR6ZGw4SHRv?= =?utf-8?B?d3VGZ0thb0hLaTFSaS9vTEQ1MHc1aFhXMkNTUHRUNGc0aGw2ODRrOWlDU2lI?= =?utf-8?B?NWNiaEl5bDJ1RW9Ka0YzQWxQVnIwQnZINXQya3l6QU1EcW9iS3NLUnZ3WlpT?= =?utf-8?B?NUU1N0plaXhaVnpQbXVsRnR2WTd5VXR5eE5jaXEyQ2NYejNPYmZwcC91WUJz?= =?utf-8?B?eEI5MW5FYmJKcWd6NkhQRUc3SC9zYSthUU9jcGtrT0NJaFhHQVBXWjhZKytV?= =?utf-8?B?NlUzWnZmYjBDQ1VNTnBvUVBUZXJEWG5YZkJkVUhsMlZOQkQxREpjUk16SmEw?= =?utf-8?B?MnFKMnh5QkJsK05wSVUralBVT2poTldrdVpGN2cwM0J6Z0t2eExRSFlSaXVL?= =?utf-8?B?RmtkTjJUNUtNOGtoZFo4TWY0S3FlUjhuSTYxQVhTTXhRbXFDQWErWmpUQVlx?= =?utf-8?B?SDRWbllsa2lmU1pPcU5wRHNMakFxbFNqUi9sSDc2RitGV01wU2NpOFJBRXJG?= =?utf-8?B?cUEwNy9sWXNoWjVmZ2JaM0NXWWo1cXVjTnRGb25yUGFjK1YvL1diM3JTY3V2?= =?utf-8?B?YU5PcW1vQ0M1ZlRkL210eXFBQkJ4cEhqZ1YrV0gyTis1Ly85NU5DNlh6TFM2?= =?utf-8?B?cE16endXUTM4UVRjVHJxZThIeHhsL05OMTRGWG9Sc1J0WE54a25BRjRzYUMy?= =?utf-8?B?U2dlWTl4bG1ScnExSjNubFZWTzZVL2xUWTBSNE1sNFkzQmhjRkhwSGJRMU1R?= =?utf-8?B?a1lnVTRvL29pMzYzZlFnZmZtcmZWdnBXZUVYVHJTM0FxTGlrN1hFS0ZvVG0x?= =?utf-8?B?aElZL1N4b3pBM1g1Yllad1NlemxYakZ0emFxRGZzeXhZLzdzQUxFZHNGV0tE?= =?utf-8?B?Q0NpV0dxM3VhTmNITU1HRUR1eDJGbTl2b3pXaTA0ZWxtZENwQ1gvb0tiNzVy?= =?utf-8?B?Z0lPdUozVHhiN0NiS3k1RHI1QzhGTkt3MnZWM2RFM1BDcTI2eXBFTDJGVmVu?= =?utf-8?B?K2hhaHpJeWIyQ3pyUjEyaGFvL2FPU2x6enNSeWU1YlNQOHVzMDBrdkFyTTdI?= =?utf-8?B?NnZENnM1NHFrZjlyYTNJNUcza3paTHl1OHZyeXhEb1RObm9wWHc4N1lUdEJq?= =?utf-8?B?bU1WVDQ3eUZxTUlhSk9IL2pLWXVBK1RTY2VVTU83SEc2Qkp0ZjR6d3F6NFBX?= =?utf-8?B?Y3dqLzhPQ3p2S1BJRDFpZDlpUU80QWVOU2VmNG8xalNYWnZuTjI0NlZBSW9s?= =?utf-8?B?MCsxNUp2NldQRy91aWpvV052RlBId01kMEQzNHJtb2NyVEZ4VHc0V3lnTXQw?= =?utf-8?B?dG1OUnRhU0J0eWtDTzlaczdmWk93SjRyaXdWVFhBY0hidkJJV24wNjZDRTBp?= =?utf-8?B?bk9leXdVb3hEY1lwSDJKRkxpOHZwQ2h5MU1udXlRPT0=?= 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: 35df0c4b-c391-4027-570d-08d8c7c9133b X-MS-Exchange-CrossTenant-originalarrivaltime: 02 Feb 2021 22:22:49.6735 (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: OHrfVRWNJvrc9c4paxR6BP028B6YW5WcuNrlz3M6zl0AU/Ho4zzF68yOf9U8TH2jGKAexLask1ghiCLqQEb7fA== X-MS-Exchange-Transport-CrossTenantHeadersStamped: CO6PR05MB7620 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk T24gVGh1LCAyMDIxLTAxLTI4IGF0IDE4OjIyICswMDAwLCBKYWNvYiBDaGFtcGlvbiB3cm90ZToN Cj4gPSBQcm9wb3NhbCA9DQo+IA0KPiBJIHByb3Bvc2UgdGhhdCBldmVyeSBhdXRoIG1ldGhvZCBz aG91bGQgc3RvcmUgdGhlIHN0cmluZyBpdCB1c2VzIHRvDQo+IGlkZW50aWZ5IGEgdXNlciAtLSB3 aGF0IEknbGwgY2FsbCBhbiAiYXV0aGVudGljYXRlZCBpZGVudGl0eSIgLS0gaW50bw0KPiBvbmUg Y2VudHJhbCBsb2NhdGlvbiBpbiBQb3J0LCBhZnRlciBhdXRoZW50aWNhdGlvbiBzdWNjZWVkcyBi dXQgYmVmb3JlDQo+IGFueSBwZ19pZGVudCBhdXRob3JpemF0aW9uIG9jY3Vycy4NCg0KVGhhbmtz IGV2ZXJ5b25lIGZvciBhbGwgb2YgdGhlIGZlZWRiYWNrISBIZXJlJ3MgbXkgc3VtbWFyeSBvZiB0 aGUNCmNvbnZlcnNhdGlvbiBzbyBmYXI6DQoNCi0gVGhlIGlkZWEgb2Ygc3RvcmluZyB0aGUgdXNl cidzIG9yaWdpbmFsIGlkZW50aXR5IGNvbnNpc3RlbnRseSBhY3Jvc3MNCmFsbCBhdXRoIG1ldGhv ZHMgc2VlbWVkIHRvIGJlIHBvc2l0aXZlbHkgcmVjZWl2ZWQuDQoNCi0gRXhwb3NpbmcgdGhpcyBp ZGVudGl0eSB0aHJvdWdoIGxvZ19saW5lX3ByZWZpeCB3YXMgbm90IGFzIHdlbGwtDQpyZWNlaXZl ZCwgbGFuZGluZyBzb21ld2hlcmUgYmV0d2VlbiAibWVoIiBhbmQgIm5vIHRoYW5rcyIuIFRoZSBt YWluDQpjb25jZXJuIHdhcyBsb2cgYmxvYXQvZXhwZW5zZS4NCg0KLSBFeHBvc2luZyBpdCB0aHJv dWdoIHRoZSBDU1YgbG9nIGdvdCB0aGUgc2FtZSByZWNlcHRpb246IGlmIHdlIGV4cG9zZQ0KaXQg dGhyb3VnaCBsb2dfbGluZV9wcmVmaXgsIHdlIHNob3VsZCBleHBvc2UgaXQgdGhyb3VnaCBDU1Ys IGJ1dCBubyBvbmUNCnNlZW1lZCBwYXJ0aWN1bGFybHkgZXhjaXRlZCBhYm91dCBlaXRoZXIuDQoN Ci0gVGhlIGlkZWEgb2YgbG9nZ2luZyB0aGlzIGluZm9ybWF0aW9uIG9uY2UgcGVyIHNlc3Npb24s IGFzIHBhcnQgb2YNCmxvZ19jb25uZWN0aW9uLCBnb3QgYSBtb3JlIHBvc2l0aXZlIHJlc3BvbnNl LiBUaGF0IHdheSB0aGUgaW5mb3JtYXRpb24NCmNhbiBzdGlsbCBiZSBvYnRhaW5lZCwgYnV0IGl0 IGRvZXNuJ3QgY2x1dHRlciBldmVyeSBsb2cgbGluZS4NCg0KLSBUaGVyZSB3YXMgYWxzbyBzb21l IGludGVyZXN0IGluIGV4cG9zaW5nIHRoaXMgdGhyb3VnaCB0aGUgc3RhdGlzdGljcw0KY29sbGVj dG9yLCBlaXRoZXIgYXMgYSBzdXBlcnVzZXItb25seSBmZWF0dXJlIG9yIHZpYSB0aGUNCnBnX3Jl YWRfYWxsX3N0YXRzIHJvbGUuDQoNCi0gVGhlcmUgd2FzIHNvbWUgZGlzY3Vzc2lvbiBhcm91bmQg KndoaWNoKiBzdHJpbmcgdG8gY2hvb3NlIGFzIHRoZQ0KaWRlbnRpZmVyIGZvciBtb3JlIGNvbXBs aWNhdGVkIGNhc2VzLCBzdWNoIGFzIFRMUyBjbGllbnQgY2VydGlmaWNhdGVzLg0KDQotIE90aGVy IGltcHJvdmVtZW50cyBhcm91bmQgdGhpcmQtcGFydHkgYXV0aG9yaXphdGlvbiBhbmQgcm9sZQ0K bWFuYWdlbWVudCB3ZXJlIGRpc2N1c3NlZCwgaW5jbHVkaW5nIHRoZSBhYmlsaXR5IHRvIGF1dG8t Y3JlYXRlDQpub25leGlzdGVudCByb2xlcywgdG8gc3luYyByb2xlIGRlZmluaXRpb25zIGFzIGEg Zmlyc3QtcGFydHkgZmVhdHVyZSwNCmFuZCB0byBxdWVyeSBhbiBleHRlcm5hbCBzeXN0ZW0gZm9y IHJvbGUgYXV0aG9yaXphdGlvbi4NCg0KKExldCBtZSBrbm93IGlmIHRoZXJlJ3Mgc29tZXRoaW5n IGVsc2UgSSd2ZSBtaXNzZWQuKQ0KDQo9PSBNeSBQbGFucyA9PQ0KDQpHaXZlbiB0aGUgZmVlZGJh Y2sgYWJvdmUsIEknbGwgY29udGludWUgdG8gZmxlc2ggb3V0IHRoZSBQb0MgcGF0Y2gsDQpmb2N1 c2luZyBvbiAxKSBzdG9yaW5nIHRoZSBpZGVudGl0eSBpbiBhIHNpbmdsZSBwbGFjZSBmb3IgYWxs IGF1dGgNCm1ldGhvZHMgYW5kIDIpIGV4cG9zaW5nIGl0IGNvbnNpc3RlbnRseSBpbiB0aGUgbG9n cyBhcyBwYXJ0IG9mDQpsb2dfY29ubmVjdGlvbnMuIEknbGwgZHJvcCB0aGUgbG9nX2xpbmVfcHJl Zml4IGZvcm1hdCBzcGVjaWZpZXIgZnJvbQ0KdGhlIHBhdGNoIGFuZCBzZWUgd2hhdCB0aGF0IGRv ZXMgdG8gdGhlIHRlc3Rpbmcgc2lkZSBvZiB0aGluZ3MuIEkgYWxzbw0KcGxhbiB0byB3cml0ZSBh IGZvbGxvdy11cCBwYXRjaCB0byBhZGQgdGhlIGF1dGhlbnRpY2F0ZWQgaWRlbnRpdHkgdG8NCnRo ZSBzdGF0aXN0aWNzIGNvbGxlY3Rvciwgd2l0aCBwZ19nZXRfYXV0aGVudGljYXRlZF9pZGVudGl0 eSgpIHRvDQpyZXRyaWV2ZSBpdC4NCg0KSSdtIGV4Y2l0ZWQgdG8gc2VlIHdoZXJlIHRoZSB0aGly ZC1wYXJ0eSBhdXRoeiBhbmQgcm9sZSBtYW5hZ2VtZW50DQpjb252ZXJzYXRpb25zIGdvLCBidXQg SSB3b24ndCBmb2N1cyBvbiB0aG9zZSBmb3IgbXkgaW5pdGlhbCBwYXRjaHNldC4gSQ0KdGhpbmsg dGhpcyBwYXRjaCBoYXMgdXNlIGV2ZW4gaWYgdGhvc2UgaWRlYXMgYXJlIGltcGxlbWVudGVkIHRv by4NCg0KLS1KYWNvYg0K