I have a containerized setup of pgAdmin4 V8.5 in server mode running.
Does anyone know if I can 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 [email protected] has a list of 3 Postgresql databases (DB1, DB2 and DB3) and is in the admins group
user [email protected] is in the readers group
user [email protected], is in the writers group
User [email protected] shares DB1 only to the readers group and DB2 only to the writers group.
Users [email protected] and [email protected] avoid having to manually configure database connections when authorizing in pgadmin4 and get the list of databases from user [email protected].
Maybe does anyone know any forks pgadmin4 (server mode) or any another applications which supports this idea I'd appreciate the information!
Thanks in advance!
Does anyone know if I can create groups for local users in pgadmin4 in web server mode and set privileges for them?
According to pgadmin.org/docs/pgadmin4/development/user_management.html , it does not support