Groups for local users pgadmin4

From: Dima P <pukalov(dot)dv(at)gmail(dot)com>
To: pgadmin-support(at)postgresql(dot)org
Subject: Groups for local users pgadmin4
Date: 2024-05-15 19:35:06
Message-ID: CACovDL6KxqyttO8iHD7U2+AbPy=tUCSEnYvY4NTxTWmxSfSXEg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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!

Attachment Content-Type Size
pgadmin4-groups.png image/png 100.0 KB

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Prachi Mishra 2024-05-19 11:34:27 unable to connect postgresql
Previous Message Cody Boorman 2024-05-14 18:28:01 Re: Expand/Collapse Nodes in Query Window