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 1lJQY1-0006O2-Qv for pgsql-hackers@arkaria.postgresql.org; Tue, 09 Mar 2021 00:48:29 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lJQY0-00034o-O1 for pgsql-hackers@arkaria.postgresql.org; Tue, 09 Mar 2021 00:48:28 +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 1lJQY0-00034g-7d for pgsql-hackers@lists.postgresql.org; Tue, 09 Mar 2021 00:48:28 +0000 Received: from mail-mw2nam10on2052.outbound.protection.outlook.com ([40.107.94.52] helo=NAM10-MW2-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 1lJQXx-0002kg-Is for pgsql-hackers@postgresql.org; Tue, 09 Mar 2021 00:48:27 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=PL54gAMnrK35b/84fzF2mW3vWEMwwZhpo1AqGfls2NNS6Z9QQTw2b5O4Wm19svAWiQ7sZOOz4x6wxKcaPWpjA+I814MLYNUefj4tx9kdjxd/56PFiNABKBWpls2vuHOKqjYopzLuWbsPMfZSHwrhj4QOXjfGJdyPF/curMkS0wmzaSZ6YhheueJxUr1v6vfNYGh/drHXWNZ8eQIitLeYD3zMQOq8okdLv1mzonqDdPsc8m6rU58dNztY4hW8cH6HbSXgs12orZ3hSTeTB6y7HZc94pASeYbtHzYcYfVmInvEgxFzdDcyRloPjZh5tSII7R0JEhA9dZ9xaMVF1nrVmA== 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=9ZjDtFe3bmgnY0r5wqfOebgw2wReTMKTBPnkVVUJaYE=; b=bT87b/KThWntdfRtTJcOU6JYytsQhkYgGwmPACsRkGC/XFo/Gyors0jR+LalGO5UkR5GWDU5oywjWFDqnU8dbEZI98Zr7KUy9GOb/rqsGV3Z15pcV/UYPZ+S3mm5hUWYolgZzPq30+x9OCeKhFVseIqb1jRQjwiPZgr+cPblx8n0RMuG4PRNckK9FfegP079sIIZi62yijEI48/vBddNUPCw20yfVY6voCMzUxqynSWh2CIByFRpV8GxWNs8UlznH77DFbULzGqa7IqvhQq4MBtVlqCstOYBoa6xuB3awiW2R7Yv5JbudLofOyE8NRTEyyuUxZOwva2+w0S5ZoVWKA== 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=9ZjDtFe3bmgnY0r5wqfOebgw2wReTMKTBPnkVVUJaYE=; b=D8/IkSa9gleSqKGA3q2DdoWpGae6W6ZUa48nqozq2U1bBoEVWFCyhoignJ1Zju29zqD6iF60x7eQ62LcxtYUuemo0gLe+rA4fCpB/RTVHd3J+yQxEM+3coK9hcojYZBbbU4lWmArYqulOXXeJsgCWxexkPt2FmkzRcQHtEqzxdM= Received: from MWHPR05MB2896.namprd05.prod.outlook.com (2603:10b6:300:65::20) by CO2PR05MB2661.namprd05.prod.outlook.com (2603:10b6:102:15::10) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.3912.9; Tue, 9 Mar 2021 00:48:20 +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; Tue, 9 Mar 2021 00:48:20 +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/fl6pFeJoAgAmCVACABIPmgIAXhdMAgAxttwCAA3O0AIAAG6GAgAAO04A= Date: Tue, 9 Mar 2021 00:48:20 +0000 Message-ID: <36ad4829f46a30b16355b60d45f43f89b89dac52.camel@vmware.com> References: <5d8b74e64fe4a610b23624277e497cc0a925db4b.camel@vmware.com> <2870147caa759155c5c8a232bbd2399f41f76491.camel@vmware.com> <4b2ca51542fa84e6fa37ab678624d5b400c092c0.camel@vmware.com> <49b2d3032f96226d2c82b370ecf6026147aeca2d.camel@vmware.com> In-Reply-To: <49b2d3032f96226d2c82b370ecf6026147aeca2d.camel@vmware.com> 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: a4ac759e-cc8d-46ee-ccd4-08d8e2950960 x-ms-traffictypediagnostic: CO2PR05MB2661: 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: pOFd3ZFL3ldnhNpBKV6iN5UYUIZEbespbXhrzh33lc/IOhxBJyVebNIL9DfErkLMBWXlm/fvk7/nXRgH+0Ywfk/PHKcrJyZFBV3Gx0SQ3SUudYCnHpR6OZjxapp1K/JrXOcZUn46pNS6zFbtbkw6b9ZOsMKR0tgfrDJDtF/9FiKKFS06UXR/YTOXKgiB3FGyDi9VRaLepdKySKNKMPIuBUmBrNTPwAqdgn1VvdcWPwXLaW7++yCwjnlkB/huyVfL8Pdj84hoZH95ghenxhOPtbJKyyXwyeP+Kh9s10nokuDDWtLhN7O3Kwjg9q+02loL1ZwFPFOPc13LJEee86ipPCBjZ8pKXQkL0yh3ReZYtx3MbaGw696kinzQfZeayGA4Yp4soZVNP2a9AUdNXCAdo4nmFyNUA+niN636stQqZioZJE+Z72FopM9k/BW90Z464krQy5vvgzVoE99VKGWtA8r17vm8A8+OF/BBGeCtfRmgR7SenQ95QoJY6MOwJjBPhMmIiVyUAfgVTjKAGNjzRw== 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)(136003)(376002)(346002)(366004)(396003)(39860400002)(5660300002)(76116006)(54906003)(6916009)(6512007)(26005)(4326008)(66556008)(316002)(64756008)(66476007)(71200400001)(2616005)(66446008)(8936002)(186003)(8676002)(6506007)(6486002)(36756003)(2906002)(66946007)(86362001)(478600001)(83380400001);DIR:OUT;SFP:1101; x-ms-exchange-antispam-messagedata: =?utf-8?B?ZUIrMy81QnNUMkUxNVJ5UG8wTWdlVkFuZlUzUXhMNlMvZTl2V05UTXdtbXZh?= =?utf-8?B?YVJCOFVyNXowNWw1a2JrbTVDVHk2bVpxVjkwVitqdE5aT1dNRkNJaVN2VVpB?= =?utf-8?B?c3FsRHZoMkVtR3ExZlFrTlBCRy9KUDYzemFEK25VNlo2T0hieFl6azVRUHYy?= =?utf-8?B?ZW4vdnU5YzA2OGdhVUViUnE5MDB1QTdranJRWFV4WGZRcnVxeDRrZk8wdmpJ?= =?utf-8?B?Y0dwdzI5eUZRdjdQWTRjYWxmNDF5UkVqOGNOTzVSMDI1a202ekJYZXErcStJ?= =?utf-8?B?cDFhQ2FudHFXUTZlKzFXVndqWVFFS0VQcVk2SW1YVnBhK0VoN0RZbzFWR1Bp?= =?utf-8?B?Tjhzb1FOZGdQTVI0R3VnazFQaks2cXFGeTNUVmNZczBoUlhhQThJbUIzZzI3?= =?utf-8?B?Wk9QNS9QbElUdjlWckJ0c2l2cFV3YUV4ZWNpdnJ6cHlPQ0hsd0pVeFU3ZzRv?= =?utf-8?B?a2h3RHFIbWd3emo5V2hkSmJKdlhFT2lIRDRKWTBtRVVFL1BKZzdKenJOOVMr?= =?utf-8?B?ZUpLUXFmYXpDSFJkRHNOLzBxNFBVUzJ0RkFFQnlZTmtydkl6WEtyY0lqZkVJ?= =?utf-8?B?RjF2SXlQYUlleVFWdkowR1l0SGl1anFsNjZWYjhMTUc2NW5Nb3dRV204MnlS?= =?utf-8?B?eGMzci94TWNEWXpBQWVMVUpJcHFwUGFBUG8rMi9EKzVHRG9OUW9jTkRlUTYw?= =?utf-8?B?MCtMblVxTGEzWnNpU21qZ0pTaU1PMmdCMHMyQnV6dTNQekt0KzN0SHk4U0E4?= =?utf-8?B?b0FYU0xUMUsyYWlaSU02RFgrUGF1d3JkcUV3STlqNmFWTWt1MXB5eHV0VDg3?= =?utf-8?B?RG5ZRnhya0R1cUhacFh5bW5tV1JXU1FKcmgxM1dGMTR6S0tTQU1Rd1BrRkNt?= =?utf-8?B?WTB6M0h2R3djQmNFaHpvODEzWkd2SHJJT3ROWTVOSHJPV09PVnVkT2dMWHI5?= =?utf-8?B?Y1ZGbHhJQjJrUzZtbnBoSmNFdXhSL1VucE01RzE5R3pzaFhjYjRKUmhmUVZS?= =?utf-8?B?R3IxMi83NXpFcmtRZFNWV3RHYmNkd1pRNG1WQmNqTWpWNldGYnh2V0RVVzZH?= =?utf-8?B?Y1BQSnVvcXRPWHN5bEwrMWg3ZkZ0YjZaSDBrM2h0eHhseE50WWU3RnJLZEpR?= =?utf-8?B?eWg3b0ZTTFdtT3NDc1NRNDBKUnNNOEoxUGNHakRiSzN3WVUwQ3JLT3Y1eUMr?= =?utf-8?B?ZGllT0FaWXZ4SW9DKzY0aEdRamJmNGpXN0RtUDJhSDBuTmErNDdxWFdmU0V5?= =?utf-8?B?cTZJblBEN09PV1ZJM2V1REc1dGN4UEkxV1pHY3o4TkVrbnNpVkQxaDN4L2Zq?= =?utf-8?B?WkJzbndPRXY2ZUJWeXlNZy9jNjhUdEVwekMyeXI3WUFxQ2VmRi9QNHRMa0Vu?= =?utf-8?B?cm55ampWRzVoZFJIZnN1ZDZRWEZyNTdYaHFZdW5BWHVSNWI5b0RwVVAwTk56?= =?utf-8?B?MlBON05ReDI3eWxubmQ0U2I2Z3h4aGM1clFCUGVqYlBpeHF3bVQwK09oTVVy?= =?utf-8?B?ejR0RDM3SVNxR1lRTmpxcCtoTUpMZzVUaDltZVRrQ2d1aEdVOHJwbWRMWGpy?= =?utf-8?B?d1REandYNXRjcHJMaXVlb1JyYzFYZUdzbFEvaklXZm1xaXl1WWlQWXdMbmRV?= =?utf-8?B?T1h0MXlIMEFOcEJ5QVFCdGJLaEl6dHdFSnBBNWlURHJwaGx5aU9MME1Va0Zt?= =?utf-8?B?MVYvWTZjS3Y4eW5oTHc1L21pS1owOGd5dnhOZkNNaWMzM2xOaVJrUXZuT3Rm?= =?utf-8?Q?BlsxqTxTmom1p02YT9V9r7PCXCJ/Z++bBHQZZVF?= 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: a4ac759e-cc8d-46ee-ccd4-08d8e2950960 X-MS-Exchange-CrossTenant-originalarrivaltime: 09 Mar 2021 00:48:20.6709 (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: U0B8ma56Pc58iZ8Xki2ke3vZuwoBgPIQhkk9s1kb2wlohrbdCFbnciLsmt3iwa5PBbAf1WpQvr7ebBSjWNUhXw== X-MS-Exchange-Transport-CrossTenantHeadersStamped: CO2PR05MB2661 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk T24gU2F0LCAyMDIxLTAzLTA2IGF0IDE4OjMzICswMTAwLCBNYWdudXMgSGFnYW5kZXIgd3JvdGU6 DQo+IEluIGZhY3QsIGlmIHdlJ3JlIHN0b3JpbmcgaXQgaW4gdGhlIFBvcnQsIHdoeQ0KPiBhcmUg d2UgZXZlbiBwYXNzaW5nIGl0IGFzIGEgc2VwYXJhdGUgcGFyYW1ldGVyIHRvIGNoZWNrX3VzZXJt YXAgLS0NCj4gc2hvdWxkbid0IHRoYXQgb25lIGFsd2F5cyB1c2UgdGhpcyBzYW1lIHZhbHVlPw0K DQpBaCwgYW5kIG5vdyBJIHJlbWVtYmVyIHdoeSBJIGRpZG4ndCBjb25zb2xpZGF0ZSB0aGlzIHRv IGJlZ2luIHdpdGguDQpTZXZlcmFsIGF1dGggbWV0aG9kcyBwZXJmb3JtIHNvbWUgc29ydCBvZiB0 cmFuc2xhdGlvbiBiZWZvcmUgY2hlY2tpbmcNCnRoZSB1c2VybWFwOiBjZXJ0IHB1bGxzIHRoZSBD TiBvdXQgb2YgdGhlIFN1YmplY3QgRE4sIFNTUEkgYW5kIEdTUyBjYW4NCm9wdGlvbmFsbHkgc3Ry aXAgdGhlIHJlYWxtLCBldGMuDQoNCj4gSVNUTSB0aGF0IGl0IGNvdWxkIGJlDQo+IHF1aXRlIGNv bmZ1c2luZyBpZiB0aGUgbG9nZ2VkIHZhbHVlIGlzIGRpZmZlcmVudCBmcm9tIHdoYXRldmVyIHdl DQo+IGFwcGx5IHRvIHRoZSB1c2VyIG1hcHBpbmc/DQoNCk1heWJlLiBCdXQgaXQncyBhbiBhY2N1 cmF0ZSByZWZsZWN0aW9uIG9mIHdoYXQncyBhY3R1YWxseSBoYXBwZW5pbmcsDQphbmQgdGhhdCdz IHRoZSBnb2FsIG9mIHRoZSBwYXRjaDogc2hvdyBlbm91Z2ggaW5mb3JtYXRpb24gdG8gYmUgYWJs ZSB0bw0KYXVkaXQgd2hvJ3MgbG9nZ2luZyBpbi4gVGhlIGNlcnRpZmljYXRlcw0KDQogICAgL09V PUFDTUUgTHRkLi9DPVVTL0NOPXBjaGFtcGlvbg0KDQphbmQNCg0KICAgIC9PVT1Qb3N0Z3Jlcy9D PUdSL0NOPXBjaGFtcGlvbg0KDQphcmUgZGlmZmVyZW50IGlkZW50aXRpZXMsIGJ1dCBQb3N0Z3Jl cyB3aWxsIHNpbGVudGx5IGF1dGhvcml6ZSB0aGVtIHRvDQpsb2cgaW4gYXMgdGhlIHNhbWUgdXNl ci4gSW4gbXkgb3BpbmlvbiwgaGlkaW5nIHRoYXQgaW5mb3JtYXRpb24gbWFrZXMNCnRoaW5ncyBt b3JlIGNvbmZ1c2luZyBpbiB0aGUgbG9uZyB0ZXJtLCBub3QgbGVzcy4NCg0KLS1KYWNvYg0K