Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1ize3g-0000my-Bs for pgsql-docs@arkaria.postgresql.org; Thu, 06 Feb 2020 10:06:52 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1ize3e-00007S-Gd for pgsql-docs@arkaria.postgresql.org; Thu, 06 Feb 2020 10:06:50 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1ize3e-00007K-8q for pgsql-docs@lists.postgresql.org; Thu, 06 Feb 2020 10:06:50 +0000 Received: from mout.kundenserver.de ([217.72.192.74]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1ize3b-00056R-E7 for pgsql-docs@lists.postgresql.org; Thu, 06 Feb 2020 10:06:49 +0000 Received: from [192.168.178.43] ([77.181.60.183]) by mrelayeu.kundenserver.de (mreue108 [212.227.15.145]) with ESMTPSA (Nemesis) id 1MGQf5-1il3aS4BsT-00GnyE for ; Thu, 06 Feb 2020 11:06:46 +0100 From: =?UTF-8?Q?J=c3=bcrgen_Purtz?= Subject: Re: Users/Roles do not align. To: pgsql-docs@lists.postgresql.org References: <158057750885.1123.2806779262588618988@wrigleys.postgresql.org> <2a273cf6-51be-a25b-5ef6-915ca727d4db@purtz.de> <20200205183005.GX3195@tamriel.snowman.net> Message-ID: Date: Thu, 6 Feb 2020 11:06:44 +0100 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:68.0) Gecko/20100101 Thunderbird/68.4.1 MIME-Version: 1.0 In-Reply-To: <20200205183005.GX3195@tamriel.snowman.net> Content-Type: text/plain; charset=windows-1252; format=flowed Content-Transfer-Encoding: 8bit Content-Language: en-US X-Provags-ID: V03:K1:6kdOnKYdlGkkBh4l5OmHvUdcKXXy+pt1I9r9+/+WIAwrfe15YX9 dkIjqSyjD71/73JqayYf08JLZFO6Z8T9vPc1P83d0zd/Zgyp7pnlFY8/ADz+J3jXKYnrgVt 8Mq9Z+dBoHSechtnJ1n/IDCSsIH/HLefFVyE68c81lczcHgCf3VJ/395IAISUmdwyeD9nDq okj7tcB+pKbGYQ5OZFyJg== X-Spam-Flag: NO X-UI-Out-Filterresults: notjunk:1;V03:K0:FQG4Qq0Fm2Y=:TpTY40F1afHGj1VFawuGmG DnQdEWyYkrb/bspEjM7f17A0be182tslr/R3ngQ4bOFTBVKRFsTWXlXv8YXcixXZ/j7/TMFhp IbySJ6N8hV6A+9umT6/ATTDp4HSAMDMPGZJpyA3ASj7JVKbzuZ8OP1AaYN+wol74ZtfEDw3SK uuf2FsAeAmnkW9NYharEBb3CiOsSArRrRO3SCtHLKuywTrFr9wpmCRtAomnFwJqHLRN2UQhRi swg2rQjuNhP3Afo1hOQdX3Itp6Qa7Z8q+nf305Im4os90kRi3BsbxYsu6REJo/RpR3vowZo3G CcI6tHpQlM7DS+0gZLaEtISqL4m9W7Rb1cWqyzDOEqpKaiB0j5S5H8ChNR6ysTe35M87a/QUc osdQL6TSU9KfSg03GZObcze9o7xop+7jAmkbsZ++aUwVQhj610na6mwajJn0StdXmG8wwngsT 63FM2kxc9WY0j/3DNOoxqcUf2h53Thx5AlQ1WyOiCLIxso3WxZxauH/H1fJrV/mEwB04kaoN/ 6zqrp3eMfqRRB+9/5SBBFfvgvwWUqUx6vL0ybc94ccaS2qLcumqioVvt9CX4PP/Vp/F4hxs0v hSeMHrxHSXTYKEbLQIgFRhXhA6g3RZd525Hu39neAhTKITZeJa9FnSjLw4KUJF7FFDEuZvmht 3Jx9lRCIAo9uAvKZBv5wmt7T5fS58o8WaYWhMEwoXzeHus0sfgbLGwFYZWFw66ff4J63oOW9Z X1gvyik5HvmgXZ5jsLq2vzHz+0iOo2bKrRHgBVIs7pnPYkfTnexPv8zddRHZl8aCXZ6LhC8SM zrWYYYpSFVSAvYLsIJDEhpSR4SrlE9ZnBDgH1/rrbc6XKBJyNodeeHtW3zP8oSRDTeUTPC0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk > There's a few things wrong about this part anyway- namely that we've got > FDWs now, and there's certainly other cluster-wide things that exist > beyond the specific items listed, so I wonder if perhaps we should just > stop trying to list everything here. Inspiring answer! After some inquiry I became aware, that we do not have only 2 levels of 'belong-to' but 3: tables, views, operators, and much more objects belong to a schema; schemata, extensions (e.g. FDW), and more(?) belong to a database; databases, roles, tablespaces, and more belong to a cluster. Two aspects of 'belong-to' are: object names are unique within their level, and objects are automatically known everywhere within their level. Information about such dependencies and their consequences is spread across different chapters of the documentation and the System Catalog. Of course the chapter about roles/users is not suitable to explain the details. But it's important to know the hierarchy, it shut be summarized somewhere. Kind regards,  J. Purtz