How do we share QGIS projects that includes PostGIS data? If I create a project loading PostGIS data with reader permissions, nobody can modify the data. If saved layers had been loaded from PostGIS with an administrator or editor's credentials then anyone opening that project can modify the data. We could create projects for individual users with PostGIS data loaded with that individual's credentials which would give the required permissions and protection but if we share that project with co-workers then they are effectively accessing the data via the first individual's credentials. I'm sure others must have come up against this but I couldn't find a solution. We are using QGIS 2.18, PostgreSQL 9.0.23 and PostGIS 1.5.
We use a generic 'reader' account rather than individual user accounts. This way they can be used to share QGIS projects with anyone who has that account set up on their QGIS instance.
The QGIS projects then reside on our shared network drive for anyone to use.
We also have an 'editor' account for those who are making data edits, and of course a 'dba'-type of account for the data owner.
Thanks DPSSpatial. We have decided to implement generic accounts for individual workflows supplying projects with data loaded using the service account and a PostGIS connection set up with the service account credentials to each team.