From: | Yogesh Mahajan <yogesh(dot)mahajan(at)enterprisedb(dot)com> |
---|---|
To: | Dima P <pukalov(dot)dv(at)gmail(dot)com> |
Cc: | pgadmin-support(at)postgresql(dot)org |
Subject: | Re: Groups for local users pgadmin4 |
Date: | 2024-05-23 04:28:30 |
Message-ID: | CAMa=N=Mqq8mXPkV=HcFC1oaPHb5SCv5Ohu0+1wvL5t38VFAVEg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
Hi,
You can use a shared server functionally to achieve your use case. Please
find the reference link here
<https://www.enterprisedb.com/blog/shared-servers-pgadmin-4> and
detailed documentation here
<https://www.pgadmin.org/docs/pgadmin4/latest/server_dialog.html>..
Thanks,
Yogesh Mahajan
EnterpriseDB
On Thu, May 16, 2024 at 2:06 PM Dima P <pukalov(dot)dv(at)gmail(dot)com> wrote:
> Hello,
>
> I have a containerized setup of pgAdmin4 V8.5 in server mode running.
>
> Could you please tell if exists any plans to add functionality in pgadmin4
> to create groups for local users in pgadmin4 in web server mode and set
> privileges for them?
>
> Basic idea
>
> To have one user with administrative privileges and who would have a list
> of databases (by server.json and .pgpass files) and give access by sharing
> database to individual groups or users.
> For example pgadmin4 has 3 users:
>
> - user admin(at)example(dot)com has a list of 3 Postgresql databases (DB1, DB2
> and DB3) and is in the admins group
>
> - user user1(at)example(dot)com is in the readers group
>
> - user user2(at)example(dot)com, is in the writers group
>
> User admin(at)example(dot)com shares DB1 only to the readers group and DB2 only
> to the writers group.
>
> Users user1(at)example(dot)com and user2(at)example(dot)com avoid having to manually
> configure database connections when authorizing in pgadmin4 and get the
> list of databases from user admin(at)example(dot)com(dot)
>
> The scheme in attachment.
>
> Maybe you know any forks pgadmin4 or any another your projects which
> supports this idea I'd appreciate the information!
>
> Thanks in advance!
>
From | Date | Subject | |
---|---|---|---|
Next Message | Prashanth Golla | 2024-05-23 13:06:41 | SSL connectivity issue from PGAdmin to Google Cloud SQL |
Previous Message | Anil Sahoo | 2024-05-20 03:54:48 | Re: unable to connect postgresql |