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 1uTZft-006KKD-9G for pgadmin-support@arkaria.postgresql.org; Mon, 23 Jun 2025 05:24:57 +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 1uTZer-00HXE9-0b for pgadmin-support@arkaria.postgresql.org; Mon, 23 Jun 2025 05:23:53 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uTZeq-00HXD3-OG for pgadmin-support@lists.postgresql.org; Mon, 23 Jun 2025 05:23:53 +0000 Received: from mail-ua1-x933.google.com ([2607:f8b0:4864:20::933]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uTZel-003USn-1f for pgadmin-support@lists.postgresql.org; Mon, 23 Jun 2025 05:23:49 +0000 Received: by mail-ua1-x933.google.com with SMTP id a1e0cc1a2514c-88150e9fba7so532646241.1 for ; Sun, 22 Jun 2025 22:23:47 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb.com; s=google; t=1750656226; x=1751261026; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=mh14DgogI9JVSHRjzQjjmElz7km+a4QmAPvtPiDZ9Qo=; b=iF7gZdM/x/mxyfOwJDwQIEJoOHdJd4FFl+832o9vsqAKtHaorkCs6yNw/H2etR5pcF gP7IGJwDjToxVb5EY+oEG/i66/gHYXbndA66/f5RVmVeYrmaugNqlL152buj2xqFUmw1 gOsshvQ4jAKd55tC4TJpKM0zVdW5GqE9l2L5d6PgI6Ibb69e8+GzlOGDtgSZ415FnaKx VACJ5unmUXplR+6UWTZtTx9xCI2WnPGpX+Y4+sWA9tpjQooy+QTmBimjVW3uB5k0k1XD DtMMFqK3nC1smWn49LE/66AR6I/lhB+eaVZc7T6eTA3/Y7xCu55bA89pOnwBf6gEt5lh K+GQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1750656226; x=1751261026; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=mh14DgogI9JVSHRjzQjjmElz7km+a4QmAPvtPiDZ9Qo=; b=wi7c/ADiBv2qQcLlymfM+whNUFDl59AmdWTaVM6D7nA4+fDEZBQtnF7q4GTsBmFODj inkiY6K5TS9g87WawAliuqJs+az5fEfS7+5AMcELCMlVR6sDgWXjIUJRNtAg3OhSDTch v0kyBS25NcBr9vjsGgVIXhZTv2e/LvTWD3CkTUdGlV0W1so1rmj5nMR2vctw8s13/GyW /E3Gb8kCIPWBREgcSwULBALRpA0BZAzb+W524W4XKUemlRSe9pjeuMj+A1+i+8Zaenos 5ZkM1wuC7w8u0+acgMnTz/0MfWqNlRTAnJyzBAlDk3kXkM+hlplzk7bbgDY4ApndZyvO Rs8Q== X-Gm-Message-State: AOJu0YxzV7M4c4dbZFj1Hv7TkE68GnK9uH5A0NJyAVjhxcCYGXZEOc5q +eiLoUAsNwBpOTvr2Ew97x5E27teTc+DwE4JsZnpC2AFhZ0o1TIS/5j/X3Qz1dZ+27jRBphYZHx GD2qrT4iUc6SdTyVrveJL3cAAaayOdbiD0S2y7pk3 X-Gm-Gg: ASbGncsefwHUZoYNZXWU49TeJwX6U17ViHUN901XnAbRYiFFbTEooRdp0axH+5DxkYK JRQa143oaUBuZahmr+GJIP2aQIos7rOfgM6J9Yx+9rcEgJ3TxgVToNo4/gq0ATbt4dhvpKEXOjx pR8P3yTJ4cwuzjx1WXHmvQ8USJNGQQaYNOVyL82wY89uP9n2ZhYXWrsWgobCbi7lgy+tJ9NmoqR Qs5EQ== X-Google-Smtp-Source: AGHT+IEqn8Z5il88SX7PEdWeZbN/SwqIKMeq0O5Ax2w/u7FfXbEj8cNiniWRsRaEsfmc0yPC2Aqkix1eiNja+V/0w1o= X-Received: by 2002:a67:e70a:0:b0:4e7:70f2:fa9b with SMTP id ada2fe7eead31-4e9c6a91ca5mr6524464137.10.1750656226252; Sun, 22 Jun 2025 22:23:46 -0700 (PDT) MIME-Version: 1.0 References: <052cf8752a1b425c65fce88f0f636244@morsberger.com> <681D8FA5-381A-496C-A9BF-169FF152D496@morsberger.com> In-Reply-To: <681D8FA5-381A-496C-A9BF-169FF152D496@morsberger.com> From: Aditya Toshniwal Date: Mon, 23 Jun 2025 10:53:11 +0530 X-Gm-Features: Ac12FXyjKh-KxiwB6i5KgHUtd4Fku1Kw5ons7GKz5Q3pTeldoMwjRHTtuUScVYU Message-ID: Subject: Re: PGAdmin User and Postgres User/Role To: David M Cc: pgadmin-support@lists.postgresql.org Content-Type: multipart/alternative; boundary="0000000000007d6de30638366ab6" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000007d6de30638366ab6 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Hi David, There is already a feature request reported here - https://github.com/pgadmin-org/pgadmin4/issues/6939. On Thu, Jun 19, 2025 at 7:19=E2=80=AFPM David M wrot= e: > 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 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. > > > --=20 Thanks, Aditya Toshniwal pgAdmin Hacker | Sr. Staff SDE II | *enterprisedb.com* "Don't Complain about Heat, Plant a TREE" --0000000000007d6de30638366ab6 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi=C2=A0David,

There is already a feature request reported= here -=C2=A0https://github.com/pgadmin-org/pgadmin4/issues/6939.

<= div class=3D"gmail_quote gmail_quote_container">
On Thu, Jun 19, 2025 at 7:19=E2=80=AFPM David M <david@morsberger.com> wrote:
I have received many v= iews and no replies.=C2=A0

Does this mean this is not po= ssible 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 mu= ltiple Postgres databases each with multiple users and roles.=C2=A0

I= s it possible to have a local PGAdmin user associated with a Postgress conn= ection that is logged in with a specific postgress user/role?

In addi= tion, is it possible to configure the PGAdmin user to only see Postgres dat= abase connections they are authorized to see?=C2=A0


This i= s not clear in the documentation and I did not see anything in the archives= .=C2=A0




--
Thanks,
Aditya Toshniwal
pgAdmin H= acker=C2=A0| Sr. Staff SDE II=C2=A0| <= a href=3D"https://www.enterprisedb.com/" target=3D"_blank">enterprisedb.com
"Don't Complain a= bout Heat, Plant a TREE"
--0000000000007d6de30638366ab6--