Soo.. since i couldn't really find answers so far:
Is there a way to share QGIS-project files that contain *encrypted* database connections? (Maybe storing them in the PG-DB..?)
..and/or to share the authentication database between clients so that the user doesn't have to pick/remember a password.
Is there maybe even a comparable thing to Esri SDE-files?
I worked quite a bit with QGIS a few years ago but these aspects of deploying it to multiple client PCs are quite unclear to me, so far.🙆♂️
Right now we use a few .mxd projects, shared on a network drive, that can be used by multiple people for editing/viewing features in a esri egdb (without exposing the db password).
We don't need more than two db-users with rw-/r-permissions. The GIS is mainly used for the graphical presentation side and editing of the geometry in cooperation with another software with its own database.
I'd like to reproduce this with QGIS, but, the more i read about it, it seems we have to do things very differently (pg_service.conf, .pgpass, other ways of authentication to the PostGIS db..?) and there is not the "easy" solution I hoped for.😬
@Hadeur
I don't think there is a way that completely prevents users from being able to get to the credentials.
Maybe check out --authdbdirectory?
I often use per-user credentials but stored in a authcfg of the same name in each user profile. That way the QGIS projects can reference authcfg "foo" and each user has their own, safe credentials in their own authcfg "foo".
Hadeur
cartocalypse