Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uSFda-005HP8-QE for pgadmin-support@arkaria.postgresql.org; Thu, 19 Jun 2025 13:49:06 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1uSFdY-00BXfm-RH for pgadmin-support@arkaria.postgresql.org; Thu, 19 Jun 2025 13:49:05 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uSFdY-00BXfe-KM for pgadmin-support@lists.postgresql.org; Thu, 19 Jun 2025 13:49:05 +0000 Received: from send.ctyme.com ([184.105.182.175]) by magus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1uSFdW-002xEw-1Q for pgadmin-support@lists.postgresql.org; Thu, 19 Jun 2025 13:49:04 +0000 Received: from 170-he.filtered.junkemailfilter.com (170-he.filtered.junkemailfilter.com [184.105.182.170]) by send.ctyme.com with ESMTPSA id CFCDF1CE1813 for ; Thu, 19 Jun 2025 06:48:58 -0700 (PDT) From: David M Content-Type: multipart/alternative; boundary="Apple-Mail=_DFFE49E1-D40B-4A2A-A536-420CD61DC927" Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3826.600.51.1.1\)) Subject: Re: PGAdmin User and Postgres User/Role Date: Thu, 19 Jun 2025 09:48:47 -0400 References: <052cf8752a1b425c65fce88f0f636244@morsberger.com> To: pgadmin-support@lists.postgresql.org In-Reply-To: <052cf8752a1b425c65fce88f0f636244@morsberger.com> Message-Id: <681D8FA5-381A-496C-A9BF-169FF152D496@morsberger.com> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --Apple-Mail=_DFFE49E1-D40B-4A2A-A536-420CD61DC927 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 I have received many views and no replies.=20 Does this mean this is not possible in PGAdmin v9.x? > On May 28, 2025, at 5:17=E2=80=AFPM, David M = wrote: >=20 > I am running PGAdmin 4 v9.1 Server. I am connecting to multiple = Postgres databases each with multiple users and roles.=20 >=20 > Is it possible to have a local PGAdmin user associated with a = Postgress connection that is logged in with a specific postgress = user/role? >=20 > In addition, is it possible to configure the PGAdmin user to only see = Postgres database connections they are authorized to see?=20 >=20 >=20 >=20 > This is not clear in the documentation and I did not see anything in = the archives.=20 >=20 --Apple-Mail=_DFFE49E1-D40B-4A2A-A536-420CD61DC927 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8 I have = received many views and no replies.

Does this = mean this is not possible in PGAdmin = v9.x?

On = May 28, 2025, at 5:17=E2=80=AFPM, David M <david@morsberger.com> = wrote:

I = am running PGAdmin 4 v9.1 Server. I am connecting to multiple Postgres = databases each with multiple users and roles.
Is it possible = to have a local PGAdmin user associated with a Postgress connection that = is logged in with a specific postgress user/role?
In addition, is = it possible to configure the PGAdmin user to only see Postgres database = connections they are authorized to see?

This is = not clear in the documentation and I did not see anything in the = archives.

= --Apple-Mail=_DFFE49E1-D40B-4A2A-A536-420CD61DC927--