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...@gmail.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 ad...@example.com has a list of 3 Postgresql databases (DB1, DB2 > and DB3) and is in the admins group > > - user us...@example.com is in the readers group > > - user us...@example.com, is in the writers group > > User ad...@example.com shares DB1 only to the readers group and DB2 only > to the writers group. > > Users us...@example.com and us...@example.com avoid having to manually > configure database connections when authorizing in pgadmin4 and get the > list of databases from user ad...@example.com. > > 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! >
