Обсуждение: PGAdmin User and Postgres User/Role

Поиск
Список
Период
Сортировка

PGAdmin User and Postgres User/Role

От
David M
Дата:

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. 

Re: PGAdmin User and Postgres User/Role

От
David M
Дата:
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 PM, 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. 


Re: PGAdmin User and Postgres User/Role

От
Aditya Toshniwal
Дата:
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 PM David M <david@morsberger.com> wrote:
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 PM, 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. 




--
Thanks,
Aditya Toshniwal
pgAdmin Hacker | Sr. Staff SDE II | enterprisedb.com
"Don't Complain about Heat, Plant a TREE"