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 1kqFV6-0005Ln-St for pgsql-admin@arkaria.postgresql.org; Fri, 18 Dec 2020 13:08:53 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kqFV5-0007f9-RV for pgsql-admin@arkaria.postgresql.org; Fri, 18 Dec 2020 13:08:51 +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 1kqFV5-0007f1-Bp for pgsql-admin@lists.postgresql.org; Fri, 18 Dec 2020 13:08:51 +0000 Received: from mail-eopbgr140138.outbound.protection.outlook.com ([40.107.14.138] helo=EUR01-VE1-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 1kqFV1-0005Zt-8G for pgsql-admin@postgresql.org; Fri, 18 Dec 2020 13:08:49 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=ZYv4Tq6i0gpTo5fEPSTUxRM73oRq+pzt2pnvoai0prhrDdfZaAoZjZiFfAgi0Xd4nmMpLoWXashR2OKJnZ49Hfg/3vTkPsEnl/YnNKTCa4R7kDB/XWdweSi/PZdXY9gnRN58RlJnZLLu6UXYr91g22k2WG3tjVdgSRkgxnjdlF3yQjRiNbvgK37qvdoH5MWE0sO5NxqVNRD9CidVSDsVf679DxI7NS+MMt6cEdyFYnG1yRjVOlrqqZL7kiwFxq9epWEMc2/1OS9Z3sG+GhaL4w+f3u5AVNLZwRLWWz+IgiN28yKHwTV6IhSlwGtyy5YdRhyd9qcKZZy287cZJV4eLw== 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=xQwUI/kAYyXD37MgcsxjYWGVJhWmnEO1mWFHi4zsgMA=; b=aI4EOFno147M6VislGrwVLeLIEC9hd9bQctjY2+KUUAhPNZtKSR+536HhKAPFWOfpeRk9tiWKC5CFAa79g8iJK5cALQuP3QW9I9rAhh9SRQ7ijCIcwgf+S9knly65HKkh7/nATpeJGlK9TW0YcdXsSUT3Z4NWtwHd1NqEORmFe29pQe0h2kU5NmABevC14H/Gihq4wh+exPsKIVQl908GnwRw+Q20WlPTh4aNwHFKB8+wDQCVsjErmWxcPLymcKvYUtRvATC/WrMZC736wUNmo2VNNsNJoosuIECRd75oWzTpLhIUjzvpWNgUYzBF06JdpqcBQl+Ta6gqLM463ey0Q== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=digia.com; dmarc=pass action=none header.from=digia.com; dkim=pass header.d=digia.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=digiaonline.onmicrosoft.com; s=selector1-digiaonline-onmicrosoft-com; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=xQwUI/kAYyXD37MgcsxjYWGVJhWmnEO1mWFHi4zsgMA=; b=mdJq74n850OXoAjdcz6UEYi1iipu3rEIhCFAk4WgScyuATzN9UneGiwb9e5/yFuMaT/pz8fXd8mj6pWbArdZAwaL9unaIL3iV5rPCZRPV+bkLMbNNDv5aU76KbHVsfCmpLOdOn2LFYnMYmq78wVJFKI+CaeUaBnLUrnUEZhi53M= Received: from DB6PR02MB3254.eurprd02.prod.outlook.com (2603:10a6:6:19::32) by DB9PR02MB7115.eurprd02.prod.outlook.com (2603:10a6:10:223::8) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.3654.15; Fri, 18 Dec 2020 13:08:43 +0000 Received: from DB6PR02MB3254.eurprd02.prod.outlook.com ([fe80::d8bc:7214:4f5c:49e7]) by DB6PR02MB3254.eurprd02.prod.outlook.com ([fe80::d8bc:7214:4f5c:49e7%3]) with mapi id 15.20.3654.025; Fri, 18 Dec 2020 13:08:43 +0000 From: Kanninen Anssi EXT To: pgsql-admin Subject: RE: User granted all access to schema, but can't see tables Thread-Topic: User granted all access to schema, but can't see tables Thread-Index: AQHW1TZdWJd9xOLNKEWbGuyhDK7y0an8x5kAgAAIsoCAAAJyAIAAAB9w Date: Fri, 18 Dec 2020 13:08:43 +0000 Message-ID: References: <43309465-eb73-557c-8941-ddad7e31a5ff@gmail.com> <84A1EF6D-B514-40BD-818C-D040D26CE6A5@gmail.com> In-Reply-To: <84A1EF6D-B514-40BD-818C-D040D26CE6A5@gmail.com> Accept-Language: fi-FI, en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: authentication-results: postgresql.org; dkim=none (message not signed) header.d=none;postgresql.org; dmarc=none action=none header.from=digia.com; x-originating-ip: [91.145.67.136] x-ms-publictraffictype: Email x-ms-office365-filtering-correlation-id: aa3997c1-e2b2-49fa-94a8-08d8a3560c1f x-ms-traffictypediagnostic: DB9PR02MB7115: x-microsoft-antispam-prvs: x-ms-oob-tlc-oobclassifiers: OLM:9508; x-ms-exchange-senderadcheck: 1 x-microsoft-antispam: BCL:0; x-microsoft-antispam-message-info: uLJoBWdluynjoCU8B25vMqSUxZPySsDxd3zHDhIfhUAmbSgZf8gTrcr4UeuTjGVkeGmWC3K6X/KnYiFsqTxdK+Tr8tWgnAGdXLe8CD5Wy1vd5181xlnbjWxdJrx9gkvo7t/SGFy5HKHY4C1CS8e2ycuQUdjPt8al08l8DEjBsrPtvIQN+h+l5SqIIxKdld2WCQ0O8HChRuW18QQvJNZDQA1wzjjPKb21nXxIBKhb2Ol/thvGySFOsVxBMkzy2OsfOI5EHZqkHrm5V+lv6NpRdPgzOPIoq2wbf+H67cadWo3ybI/xTvQ8p+LOHTxg8307VzUEJm1jTBLSVEIr4tzQyQ== x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:DB6PR02MB3254.eurprd02.prod.outlook.com;PTR:;CAT:NONE;SFS:(4636009)(376002)(136003)(346002)(366004)(39850400004)(396003)(53546011)(6506007)(52536014)(83380400001)(66556008)(76116006)(64756008)(6916009)(33656002)(478600001)(8676002)(66946007)(71200400001)(66446008)(26005)(66476007)(9686003)(186003)(316002)(2906002)(55016002)(8936002)(86362001)(5660300002)(7696005);DIR:OUT;SFP:1102; x-ms-exchange-antispam-messagedata: =?utf-8?B?cm9SbTN3SDdJOEdpcVlhZWZCVEFYNkhyRzlVVFF2QVFrbVlPcEV4ZFo3OVBy?= =?utf-8?B?VWlhcjYwc1NoMTRCYVBHalhldVlOZ1QwMjh3bWtHeDJJZmZSR2VEdjBzRTFz?= =?utf-8?B?cklmUVJ5dEpMenZaUXNocHpMZEx2VWFqOTVPVWtyT2R0WHM3MzZGczdMMjJ1?= =?utf-8?B?UERRUE9vTk9BZzFRVldKdnJVekxSYjZ4bzBxTTY2Q3NrWFBqb21iQXdKM3E0?= =?utf-8?B?dElHakEySVBybjYycFNaQzRlZVgyNXdQcXVqb3lEWmd2VkRLQVdxbUY5Nis2?= =?utf-8?B?eWNnNHIvaFBWc0l4NXFJNUVzWmg4cG9DWkZCbzN1SDF4TDgrWVlxTW51L1ZI?= =?utf-8?B?V3JDeG9TQkt1TWxCU1RTUUZmZ3BJNUswZkdKbkoyL24wMzAvVGdUdm9NNy9i?= =?utf-8?B?WFJ5SUY4ZlVjZ1crNGNxdTJtcTBmOWZTT3EzLy90QkZ1cTM3ME9VbXJmSTFL?= =?utf-8?B?eTUyUTVjQnU0SU9iakZueGY1UGEwOHgzaVBGYUpiTWxnOCs3ZmM1UDdFd0RR?= =?utf-8?B?c1NVNHcwempIeXVYMzJJekc1OSszbHk2UGVldUc3bGhoR1NVSm9ja0xIeGJw?= =?utf-8?B?R3A1YnZxS3ZPdkFldXllRDBJcFVtN25FMUFnR1dmc211Z21GY2JtOWVDVlFL?= =?utf-8?B?QldESERnV01iY2l1ek9yMENpeEkrZ2xPZjJFRHQyY1NDd0hPQWZ4OEd3REUv?= =?utf-8?B?MHBaWlNqKzVwM0dpUzY5VnY5VjFyWHd1bFMzNFM4NGZDR1FsNFFjdWhBZTJJ?= =?utf-8?B?VmovMS9uSnRFeGRnczU4aDRJRVNUcThBajlpZ2pwVDdsWm5NbjJaL3d3QW40?= =?utf-8?B?ejNmK1hqVmJIN1VQL2JqODhwYjducDlGYTZEc28vS1FBZmwwZEw5VENkeW91?= =?utf-8?B?RXF4Smw3akVCZ2FiWU9ZSGtrTm4xSTUxbFVJd2QzVlNOVnVMeWl1ZzhVUlly?= =?utf-8?B?ZWFhUk4vbStBeVNVMnY4cHBJMURkVWN0RXJRdGl2TElBUkIxaUNoME9EOHFK?= =?utf-8?B?ejdGSGFVNFpKZEYremxRbEhIZk0xVHdYWng5YXg4TUlpU0cxOCtia2NGV0Jh?= =?utf-8?B?cFloUmNveUtEeFp2MmtSQVJIRGloMHhqWS9yZS9tc2lINlZlRTZtdnR5L05o?= =?utf-8?B?MlB1WnpvWmk5YnlFTXpGcnozYVZpUWl2OGRKRDA0YXJRaE1sUTNDWTNiRTJq?= =?utf-8?B?UVV3ajc3aWtnYXRnUEVLU3AyT3NBZGU3ZllsMisxZElNd25uQnV6YUJ4SHJC?= =?utf-8?B?Vk0rdEk1WVFVYm1hNWJZRjRVVDUrNTcxTEFQNml3a3FmRk4xVy9pM01IRm1U?= =?utf-8?Q?xAGuU2uzqtPT0=3D?= x-ms-exchange-transport-forked: True Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 MIME-Version: 1.0 X-OriginatorOrg: digia.com X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: DB6PR02MB3254.eurprd02.prod.outlook.com X-MS-Exchange-CrossTenant-Network-Message-Id: aa3997c1-e2b2-49fa-94a8-08d8a3560c1f X-MS-Exchange-CrossTenant-originalarrivaltime: 18 Dec 2020 13:08:43.7637 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 6fce4bb8-3501-41c9-afcc-db0fb51c7e3d X-MS-Exchange-CrossTenant-mailboxtype: HOSTED X-MS-Exchange-CrossTenant-userprincipalname: xuXHw3dskQ1uSa+yggypOlQqdbCBKPS8Mi2o9k4UKd681AmYIDkZlWxI5I1ZsVq3yq4T/V29faagR2G9E9Al+v6gkHd39yyvHCKJuikE2Ss= X-MS-Exchange-Transport-CrossTenantHeadersStamped: DB9PR02MB7115 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk SWYgeW91IHdhbnQgdG8gZ3JhbnQgdGhlIHByaXZpbGVnZXMgYWZ0ZXIgdGhlIHRhYmxlcyBoYXZl IGNyZWF0ZWQsIGRvOg0KR1JBTlQgQUxMIE9OIEFMTCBUQUJMRVMgSU4gU0NIRU1BIHN0cmFucyBU TyBzdHJhbnN1c2VyOw0KDQotLS0tLU9yaWdpbmFsIE1lc3NhZ2UtLS0tLQ0KRnJvbTogSm9obiBT Y2FsaWEgPGpheWtub3dzdW5peEBnbWFpbC5jb20+IA0KU2VudDogcGVyamFudGFpIDE4LiBqb3Vs dWt1dXRhIDIwMjAgMTUuMDYNClRvOiBSb24gPHJvbmxqb2huc29uanJAZ21haWwuY29tPg0KQ2M6 IHBnc3FsLWFkbWluIDxwZ3NxbC1hZG1pbkBwb3N0Z3Jlc3FsLm9yZz4NClN1YmplY3Q6IFJlOiBV c2VyIGdyYW50ZWQgYWxsIGFjY2VzcyB0byBzY2hlbWEsIGJ1dCBjYW4ndCBzZWUgdGFibGVzDQoN ClRyeSBkb2luZyBhIFxkcHAgPHRhYmxlX25hbWU+IGFuZCBzZWUgaWYgdGhlIHRhYmxlIGNvbnRh aW5zIGEgbGluZSBmb3IgdGhlIHN0YW5zdXNlci4gUGVyaGFwcyB0aGVyZSB3YXMgYSBwcm9ibGVt IHdpdGggdGhlIGRlZmF1bHQgcHJpdmlsZWdlcy4gT2gsIGFuZCBjYXNlIHlvdSBkaWRu4oCZdCBr bm93IHRoaXMsIG5ld2x5IHNldCBkZWZhdWx0IHByaXZpbGVnZXMgb25seSBlZmZlY3QgYW4gb2Jq ZWN0IGNyZWF0ZWQgYWZ0ZXIgdGhlIGZhY3QsIHRoZXkgZG8gbm90IGFsdGVyIHByaXZpbGVnZXMg Zm9yIGFueSBleGlzdGluZyBvYmplY3QuDQoNClNlbnQgZnJvbSBteSBpUGFkDQoNCj4gT24gRGVj IDE4LCAyMDIwLCBhdCA3OjU3IEFNLCBSb24gPHJvbmxqb2huc29uanJAZ21haWwuY29tPiB3cm90 ZToNCj4gDQo+IO+7v1RoZSBkYXRhYmFzZSBuYW1lIGlzICJzaWRlcyIsIGFzIHNob3cgaW4gdGhl IHBzcWwgcHJvbXB0LiAgVXNlciAic3RyYW5zdXNlciIgY2FuIGNvbm5lY3QgdG8gdGhlIGRhdGFi YXNlIGFzIHNob3duIGJlbG93IHdoZW4gaXQgdHJpZXMgdG8gcXVlcnkgdGFibGVzIGJ1dCBnZXRz ICJwZXJtaXNzaW9uIGRlbmllZCIuDQo+IA0KPj4gT24gMTIvMTgvMjAgNjoyNiBBTSwgSm9obiBT Y2FsaWEgd3JvdGU6DQo+PiBEb2VzIHRoZSBzdGFuc3VzZXIgaGF2ZSBjb25uZWN0IHByaXZpbGVn ZXMgdG8gdGhlIGFjdHVhbCBkYXRhYmFzZSB3aGVyZSB0aGUgc2NoZW1hIGFuZCB0YWJsZXMgYXJl Pw0KPj4gDQo+PiBHUkFOVCBjb25uZWN0IE9OIERBVEFCQVNFIDxzdGFuc193aGF0ZXZlcj4gVE8g c3RhbnN1c2VyOw0KPj4gDQo+PiBOb3RlIHRoYXQgc2luY2UgeW91IGRpZG7igJl0IHRlbGwgdXMg d2hhdCB0aGUgZGF0YWJhc2UgbmFtZSBpcyBoZXJlLCB5b3XigJlsbCBuZWVkIHRvIHN1YnN0aXR1 dGUgdGhlIGFjdHVhbCBuYW1lIG9mIGl0IHdoZXJlIEkgaW5kaWNhdGVkIDxzdGFuc193aGF0ZXZl cj4uDQo+PiDigJQNCj4+IEpheQ0KPj4gDQo+PiBTZW50IGZyb20gbXkgaVBhZA0KPj4gDQo+Pj4+ IE9uIERlYyAxOCwgMjAyMCwgYXQgNzowNyBBTSwgUm9uIDxyb25sam9obnNvbmpyQGdtYWlsLmNv bT4gd3JvdGU6DQo+Pj4gDQo+Pj4g77u/VGhpcyBpcyB2MTIgZnJvbSBSSEVMIHJlcG9zLg0KPj4+ IA0KPj4+IEFzIHVzZXIgcG9zdGdyZXMsIEkgcnVuOg0KPj4+IA0KPj4+IHNpZGVzPSMgZ3JhbnQg YWxsIG9uIFNDSEVNQSBzdHJhbnMgVE8gc3RyYW5zdXNlcjsgR1JBTlQNCj4+PiANCj4+PiBzaWRl cz0jIEFMVEVSIERFRkFVTFQgUFJJVklMRUdFUyBJTiBTQ0hFTUEgc3RyYW5zIEdSQU5UIGFsbCBv biANCj4+PiB0YWJsZXMgdG8gc3RyYW5zdXNlcjsgQUxURVIgREVGQVVMVCBQUklWSUxFR0VTDQo+ Pj4gDQo+Pj4gc2lkZXM9IyBHUkFOVCBVU0FHRSBPTiBTQ0hFTUEgc3RyYW5zIFRPIHN0cmFuc3Vz ZXI7IEdSQU5UDQo+Pj4gDQo+Pj4gQnV0IHVzZXIgc3RyYW5zdXNlciBzdGlsbCBjYW7igJl0IGFj Y2VzcyB0YWJsZXMNCj4+PiANCj4+PiBzaWRlcz0+IFxkDQo+Pj4gICAgICAgICAgICAgIExpc3Qg b2YgcmVsYXRpb25zDQo+Pj4gU2NoZW1hIHwgICAgTmFtZSAgICB8ICAgVHlwZSAgIHwgIE93bmVy DQo+Pj4gLS0tLS0tLS0rLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0rLS0tLS0tLS0tLQ0KPj4+IHN0 cmFucyB8IGZvbyAgICAgICAgfCB0YWJsZSAgICB8IHBvc3RncmVzDQo+Pj4gc3RyYW5zIHwgZm9v X2lkX3NlcSB8IHNlcXVlbmNlIHwgcG9zdGdyZXMNCj4+PiAoMiByb3dzKQ0KPj4+IA0KPj4+IHNp ZGVzPT4gc2VsZWN0ICogZnJvbSBzdHJhbnMuZm9vOw0KPj4+IEVSUk9SOiAgcGVybWlzc2lvbiBk ZW5pZWQgZm9yIHRhYmxlIGZvbw0KPj4+IA0KPj4+IHNpZGVzPT4gXHogc3RyYW5zLmZvbw0KPj4+ ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgQWNjZXNzIHByaXZpbGVnZXMNCj4+PiBT Y2hlbWEgfCBOYW1lIHwgVHlwZSAgfCAgICAgQWNjZXNzIHByaXZpbGVnZXMgICAgIHwgQ29sdW1u IHByaXZpbGVnZXMgfCBQb2xpY2llcw0KPj4+IC0tLS0tLS0tKy0tLS0tLSstLS0tLS0tKy0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0NCj4+ PiBzdHJhbnMgfCBmb28gIHwgdGFibGUgfCBwb3N0Z3Jlcz1hcndkRHh0L3Bvc3RncmVzK3wgICAg ICAgICAgICAgICAgICAgfA0KPj4+ICAgICAgICB8ICAgICAgfCAgICAgICB8IFJFQURXUklURT1h cndkRC9wb3N0Z3JlcyArfCAgICAgICAgICAgICAgICAgICB8DQo+Pj4gICAgICAgIHwgICAgICB8 ICAgICAgIHwgUkVBRE9OTFk9ci9wb3N0Z3JlcyB8ICAgICAgICAgICAgICAgICAgIHwNCj4+PiAo MSByb3cpDQo+Pj4gDQo+Pj4gV2hhdCBhbSBJIG1pc3Npbmc/DQo+Pj4gDQo+Pj4gLS0NCj4+PiBB bmd1bGFyIG1vbWVudHVtIG1ha2VzIHRoZSB3b3JsZCBnbyAncm91bmQuDQo+Pj4gDQo+Pj4gDQo+ IA0KPiAtLQ0KPiBBbmd1bGFyIG1vbWVudHVtIG1ha2VzIHRoZSB3b3JsZCBnbyAncm91bmQuDQo+ IA0KPiANCg0KDQo=