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 1l6hsU-0003u4-Qi for pgsql-hackers@arkaria.postgresql.org; Mon, 01 Feb 2021 22:41:02 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1l6hry-0003Lj-7f for pgsql-hackers@arkaria.postgresql.org; Mon, 01 Feb 2021 22:40:30 +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 1l6hry-0003Lb-0T for pgsql-hackers@lists.postgresql.org; Mon, 01 Feb 2021 22:40:30 +0000 Received: from mail-dm6nam11on2060.outbound.protection.outlook.com ([40.107.223.60] helo=NAM11-DM6-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 1l6hrq-0001AM-Pb for pgsql-hackers@postgresql.org; Mon, 01 Feb 2021 22:40:29 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=VVblPoNagzGCEHIkCTOip2k2Oj5m5V8+DObKdfRLlprVzE1fkOhTThPim6S21j5ineILqb6WbmsoxOQRtVH2XGPldwIHQIrqZn+Xbiij0RT5Mez63KVqWE0Arz21GY2J6ADQsKwpMkb4d5ZgqkT9BjHrEIYRNx1AhRKryCY1MW7un7ZoUIgXFOaHdYfEpr7iyhOy3z5x/0wiYkJelNk2Sbb9+Ui6G2TzPhE4W6nh5fblExPHLPcDB84IRoaJZlW1XTXMyAJU9TXlIy/A6eSbOg/ls1k+Mu5y3qu/kXyY90wpwu8gxXwjhaMrdigbuhgXdY4OrxdH+mPTIVk9K0yMrw== 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=JOWBq19e1QT2XvrgpFybfPfv+kWTxuYGmtpygWVWplo=; b=kAMJHSHT6xWPJqrY0qL7wLuwXUtqs+MEfhy2qa6jZ5sJTYGKfO/Qxfy6EGfqgaYOQEE0meuVaqaAWXL5IST2C3r8gbtDAZTLW1dZMooQzoIPLnMY9TNcd+AmLi7iojkHN108WNSYFgV08B3TIKXoPzhL/FQywMJ9DZc1ooxaiOQZ0uLZcgn0++4KHTRHLmrif9/4VZdwVv47YLkoYgPC+EFWGpnBdgGNAvk+CCKptnDls40fqfmQ5TK0Slz98kRix64aqKh2aXCen/rfT8Wn2xLon70zvkNuX1Jx0eNf/ksko7Tr6VkIoGgcMYBD2ysb442yTqGpWGXUM5lNXBgsKQ== 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=JOWBq19e1QT2XvrgpFybfPfv+kWTxuYGmtpygWVWplo=; b=pn0gVeiMwum1gVHx6Hob7ADvS1a5V/6DVet8uMdLczmP+E5jTrpuVShfOsnQBxf70RQstd7cW5aKkH7ZMJdAdIeSYexG9pef9BetKagJZiQ3qssRyA5KxFpWQY9fVQg9SgHyUk5EgAROZPfSNmV1LjfiYzB731VjnvgI9BKovA8= Received: from (2603:10b6:300:65::20) by MWHPR05MB3248.namprd05.prod.outlook.com (2603:10b6:300:b4::11) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.3825.8; Mon, 1 Feb 2021 22:40:18 +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; Mon, 1 Feb 2021 22:40:18 +0000 From: Jacob Champion To: "sfrost@snowman.net" CC: "magnus@hagander.net" , "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/KTGAgAAWgoCAAl07gIAB7BqAgABUUoCAAALzAIAACtuA Date: Mon, 1 Feb 2021 22:40:18 +0000 Message-ID: References: <20210129220101.GE27507@tamriel.snowman.net> <20210201164905.GI27507@tamriel.snowman.net> <57b741e9388f3bd97486615ea1f968c8eee9f055.camel@vmware.com> <20210201220126.GW27507@tamriel.snowman.net> In-Reply-To: <20210201220126.GW27507@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: 56c8039c-4d83-4174-9f00-08d8c7025a14 x-ms-traffictypediagnostic: MWHPR05MB3248: x-microsoft-antispam-prvs: x-ms-oob-tlc-oobclassifiers: OLM:8882; x-ms-exchange-senderadcheck: 1 x-microsoft-antispam: BCL:0; x-microsoft-antispam-message-info: 2ZsrqJYNuhntmtqfejB+TG0XmR5QPCLcSUOoZKkJCg87vBuROrVE5SlpP5k5LLAi3B3f6fKgwUZHTkvRM6csOfUHgywpMJUwAGErIIqt/Kib0znlAVDydzh7NhhpsMt7kvhxURZm4Ebzo9lzlqmDyZGBukbpOVuRjp+YccInTqodGrE56CDtwZxsX2YJXwua1lEV65pQ+LFl2B7fM0ECo4auf8ACDNyKgqM7RL/0ML9d+xLKiDCDJtgK7C4QkYmEYzXZmhiQ4OFQO1wCtifli3t6gocFpS1+5B0jfpOflNByKbAzqtpCaKpJ6blW8CvM439vqWq1Di+/B3kMuyiS/BMtTCYCuJcBoP3wcY2XxeFOidr35VIaxlf2MPGbOdt2uKnUq4aT8VAwK2bXGF6XGyDNCAK6WrGk/5ZHn6uzCfNUl8epXkS3KRyVXt/y4k18ZX0bUMh44DVh9/RvHlRnNcCfm+ugkPZxVEgTFpp1O5Qjwu+TDTq+KQ80C96kk1pC1+ksOA2SAbLT7C69rXyTGQ== 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)(376002)(366004)(396003)(2616005)(6486002)(5660300002)(478600001)(86362001)(4326008)(6512007)(186003)(2906002)(6506007)(54906003)(8676002)(71200400001)(26005)(36756003)(66946007)(83380400001)(6916009)(76116006)(64756008)(66476007)(66556008)(66446008)(8936002)(316002);DIR:OUT;SFP:1101; x-ms-exchange-antispam-messagedata: =?utf-8?B?U3RuMWFTNnRJUGdqUjBJZktac0VWdDA5VHB3QkNOV3Ivb0Z6N0NpVGNTd1A2?= =?utf-8?B?N0FOZEV4MktoUWFkb0pNUCtqaWpjSk0rdWFicndIMmdpRnJTd0FaR0p1a0F2?= =?utf-8?B?aTlRaUl1TmVOcWNiZk9Vdlhqc2w2a1pacjVUcWhEa3haZGdGNTFoZHhXV2Ja?= =?utf-8?B?WGhycHVLU0VvVUEwUXJQcm9HUCsxRVdyT09lc2dEU2xWSktBM3J0MkF0cTRi?= =?utf-8?B?eUNySDFNZnZRYmttd2wyUkpZdjgvTFJHTEc4Wm1lcnBUdmdtZlhCYlNvNkdw?= =?utf-8?B?by8vM2hURjVUNHRJOHBUZjlSOWpMNjBwdzZRNEpOQVg4NzlCb3hMQUJTeEJM?= =?utf-8?B?RkhLUy9qd1IxcE8yd2dLUnFVZGVaRTUzQVV0TnJxb2VLdzkzQXVjOCt2NGI0?= =?utf-8?B?aXg2Z0lRVHVmVXN4bzRNa1ZBQXk2UmY4bks3NjA5Y05tQjVFcjVIQmpHWVZD?= =?utf-8?B?Nkl1ZDhnZEJ3dERRQis3REpIRVREVXdhVUxXNGVCem53SVYrMW1zWFpOa3ow?= =?utf-8?B?ZGd2RWxUZ0xjOWFwalg1OU9sWUZKdXA3Qk9GczBMYkY0dlVtbkxvM09jRXd4?= =?utf-8?B?dnB6WTFxdEFrakt1a1NJc3ZhNnR4b2JVbUl1bW9VUmhpdkxqQWZjVzJEV3dW?= =?utf-8?B?TURiRm5lV05nTW1UVS9jUmViWUFZMHYrMWNvc0tSSXExcGMzbCtxRTljTXJE?= =?utf-8?B?bm1CSTJJaVNYOXRtVXh6M3hXNVlFOU5ZUVk5NnM0ajNVRkpGeEJxWmZoWU0r?= =?utf-8?B?Nlp0SGR1UFNwemxLbFh6U1lMdkk1R1poenBocEZjY0dGY3ppaWlVWTc2K29q?= =?utf-8?B?TzJHUWxZVXFNQXNYemgvZFdTNlM5bmZjN09yZ0ZsRVRUamUzdXZjRnpaSER2?= =?utf-8?B?SEt4OVROeU1zdkZkcXNKYjdYRDNNN1ZQUW5KeHNTMmxQS0dZcXdpbStuSDk5?= =?utf-8?B?VHdSVnYzNUNiRTlYU1NCdHdzRitKWWNGSGhVMlU4amVmcjIrWmQraXRRUEVK?= =?utf-8?B?K2FGNXJKZlNoVXpSNjR1MnNmSG9TWUlKVzBPWlF5ZjdCeS8wWW9kaWN1ekRh?= =?utf-8?B?T0J2a011SlhLenF2Mm84ZmlqNk5nQ2tpbndxM2N1UXlqSkd2d1JSc3M2cTly?= =?utf-8?B?bmpsc3MraEh4YWppeXZqdTVraHFYdStKcTAxK2kxM3BEcjZsNDFVdFo0ZGRv?= =?utf-8?B?QXliV2w3MEkxdGRSR1h3Qk9JQ3dPUlZGMEl5US9vRHNEVDBmSlcxTk0zTGhN?= =?utf-8?B?SHU4WUs4aDFoNlp4V044WGduS2tIbzNDOU9XRVRrRmdveW56Vm4zYjE3dWtF?= =?utf-8?B?NkpuU045bU5TZGo2T01pc0gwd21ZRTdieWhPcmduL1hkQWJ2cEZhRUo0NHRq?= =?utf-8?B?V0pWUGYyZGdtVXBXcXI5SngrcUZqeFhxTTJmNWZBZzYzWVhGN01wR1kxUXBT?= =?utf-8?B?MVdoNmJJN1lESTBTY2NvTVNXTHVvMWdqWU1tR1JnPT0=?= x-ms-exchange-transport-forked: True Content-Type: text/plain; charset="utf-8" Content-ID: <87DF3075015C474A963653428C78C4B4@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: 56c8039c-4d83-4174-9f00-08d8c7025a14 X-MS-Exchange-CrossTenant-originalarrivaltime: 01 Feb 2021 22:40:18.6198 (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: vcJVSSUMmW/+oYw4PGYQIeCo7ZJOUlSUR9s0f8o1qUnVBxql7BWYKrcW4XZo88zvKSxv6QDbx3ArQpLZrWlWeQ== X-MS-Exchange-Transport-CrossTenantHeadersStamped: MWHPR05MB3248 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk T24gTW9uLCAyMDIxLTAyLTAxIGF0IDE3OjAxIC0wNTAwLCBTdGVwaGVuIEZyb3N0IHdyb3RlOg0K PiAqIEphY29iIENoYW1waW9uIChwY2hhbXBpb25Adm13YXJlLmNvbSkgd3JvdGU6DQo+ID4gQW5k IEknbSBub3QgaG9sZGluZw0KPiA+IG15IGJyZWF0aCBmb3IgTERBUCBzZXJ2ZXJzIHRvIHN0YXJ0 IGltcGxlbWVudGluZyBmZWRlcmF0ZWQgaWRlbnRpdHksDQo+ID4gdGhvdWdoIHRoYXQgd291bGQg YmUgbmljZS4NCj4gDQo+IE5vdCBzdXJlIGV4YWN0bHkgd2hhdCB5b3UncmUgcmVmZXJyaW5nIHRv IGhlcmUgYnV0IEFEIGFscmVhZHkgcHJvdmlkZXMNCj4gS2VyYmVyb3Mgd2l0aCBjcm9zcy1kb21h aW4gdHJ1c3RzIChha2EgZm9yZXN0cykuICBUaGUgZnV0dXJlIGlzIGhlcmUuLj8NCj4gOikNCg0K SWYgdGhlIGVuZCB1c2VyIGlzIGFjdHVhbGx5IHVzaW5nIExEQVAtb24tdG9wLW9mLUFELCBhbmQg Y29tZm9ydGFibGUNCmFkbWluaXN0ZXJpbmcgdGhlIEtlcmJlcm9zLXJlbGF0ZWQgcGllY2VzIG9m IEFEIHNvIHRoYXQgdGhlaXIgKm5peA0Kc2VydmVycyBhbmQgdXNlcnMgY2FuIHNwZWFrIGl0IGlu c3RlYWQsIHRoZW4gc3VyZS4gQnV0IEkgY29udGludWUgdG8NCmhlYXIgYWJvdXQgY3VzdG9tZXJz IHdobyBkb24ndCBmaXQgaW50byB0aGF0IG1vbGQuIDpEIEVub3VnaCB0aGF0IEkNCmhhdmUgdG8g a2VlcCBhbiBleWUgb24gdGhlICJwdXJlIiBMREFQIHNpZGUgb2YgdGhpbmdzLCBhdCBsZWFzdC4N Cg0KPiA+IFRvIGRvdWJsZS1jaGVjayAtLSBzaW5jZSBnaXZpbmcgdGhpcyBhYmlsaXR5IHRvIHRo ZSBwZ19yZWFkX2FsbF9zdGF0cw0KPiA+IHJvbGUgd291bGQgZXhwYW5kIGl0cyBzY29wZSAtLSBj b3VsZCB0aGF0IGJlIGRhbmdlcm91cyBmb3IgYW55b25lPw0KPiANCj4gSSBkb24ndCBhZ3JlZSB0 aGF0IHRoaXMgcmVhbGx5IGV4cGFuZHMgaXRzIHNjb3BlLSBpbiBmYWN0LCB5b3UnbGwgc2VlDQo+ IHRoYXQgdGhlIEdTU0FQSSBhbmQgU1NMIHVzZXIgYXV0aGVudGljYXRpb24gaW5mb3JtYXRpb24g aXMgYWxyZWFkeQ0KPiBhbGxvd2VkIHVuZGVyIEhBU19QR1NUQVRfUEVSTUlTU0lPTlMoKS4NCg0K QWgsIHNvIHRoZXkgYXJlLiA6KSBJIHRoaW5rIHRoYXQncyB0aGUgd2F5IHRvIGdvLCB0aGVuLg0K DQotLUphY29iDQo=