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 1pRhid-0005vF-CK for pgsql-general@arkaria.postgresql.org; Mon, 13 Feb 2023 22:54:43 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pRhib-0005pg-3I for pgsql-general@arkaria.postgresql.org; Mon, 13 Feb 2023 22:54:41 +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 1pRhia-0005p3-OS for pgsql-general@lists.postgresql.org; Mon, 13 Feb 2023 22:54:40 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pRhiT-00076d-W8 for pgsql-general@postgresql.org; Mon, 13 Feb 2023 22:54:39 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.15.2/8.15.2) with ESMTP id 31DMsW6r1515581; Mon, 13 Feb 2023 17:54:32 -0500 From: Tom Lane To: Damian Carey cc: Postgresql Subject: Re: HOWTO? Permissions for user to access a single db In-reply-to: References: <1510083.1676325588@sss.pgh.pa.us> Comments: In-reply-to Damian Carey message dated "Tue, 14 Feb 2023 09:44:09 +1100" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <1515579.1676328872.1@sss.pgh.pa.us> Date: Mon, 13 Feb 2023 17:54:32 -0500 Message-ID: <1515580.1676328872@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Damian Carey writes: > The PP product is on MSSQL, so they use some connector (sorry, no idea > what) from the customer PC to access my PG14 on Ubuntu. Black boxes are fun aren't they. > This is their screenshot supplied to me of a working connection .... > [image: image.png] > Below is our second trial/proof-of-concept where I tried to limit them to > ONLY need-to-know on the one shared database they read from. > It seems they are accessing (the one and only) PG cluster on the VPS, but > no database is visible, only "default". > [image: image.png] These images didn't come through, but they probably wouldn't have added anything anyway. It seems that either their connector is doing something strange or you misconfigured things on your side, but there's no evidence here to say which. I'd counsel enabling log_connections, and maybe log_statements too, and then looking into the postmaster log to see what happens when they try to connect. regards, tom lane