Re: Groups for local users pgadmin4

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!
>