pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Damian Carey <jamianb@gmail.com>
Cc: Postgresql <pgsql-general@postgresql.org>
Subject: Re: HOWTO? Permissions for user to access a single db
Date: Mon, 13 Feb 2023 17:54:32 -0500
Message-ID: <1515580.1676328872@sss.pgh.pa.us> (raw)
In-Reply-To: <CA+QCafcdMdBtuiyDF_o2h_wac2MDqUxka82MtwAc-Tq8eRLXWA@mail.gmail.com>
References: <CA+QCafdWu7Qd13wRdjdyubhCtUMhDsuDUZLHYNA7jvqhWjdxbQ@mail.gmail.com>
	<1510083.1676325588@sss.pgh.pa.us>
	<CA+QCafcdMdBtuiyDF_o2h_wac2MDqUxka82MtwAc-Tq8eRLXWA@mail.gmail.com>

Damian Carey <jamianb@gmail.com> 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





view thread (10+ messages)  latest in thread

Message-ID: <1515580.1676328872@sss.pgh.pa.us>
Permalink:  ../1515580.1676328872@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/1515580.1676328872@sss.pgh.pa.us

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-general@postgresql.org
  Cc: tgl@sss.pgh.pa.us, jamianb@gmail.com
  Subject: Re: HOWTO? Permissions for user to access a single db
  In-Reply-To: <1515580.1676328872@sss.pgh.pa.us>
  References: <CA+QCafdWu7Qd13wRdjdyubhCtUMhDsuDUZLHYNA7jvqhWjdxbQ@mail.gmail.com> <1510083.1676325588@sss.pgh.pa.us> <CA+QCafcdMdBtuiyDF_o2h_wac2MDqUxka82MtwAc-Tq8eRLXWA@mail.gmail.com> <1515580.1676328872@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox