Maybe all that you need is in the QHIS auth system is https://docs.qgis.org/3.10/en/docs/user_manual/auth_system/auth_workflows.html#changing-authentication-config-id
The master password can be stored in the operating system wallet so that the user will not need to type his password. Regards On Fri, May 29, 2020, 19:39 Cliff Patterson <cpatter...@psdrcs.com> wrote: > PS: I realize I can create maps with basic auth and not store the PW, > which prompts the user to enter their creds. But is there a better way now > to achieve the same result? > > Cliff > > On Fri, May 29, 2020 at 1:29 PM Cliff Patterson <cpatter...@psdrcs.com> > wrote: > >> What is the best approach to save QGIS projects to PostgreSQL >> without saving the project-creator's credentials/permissions? If the DB >> admin creates a project and saves it to the DB, anyone opening that project >> will attain the admin's permissions on layers in that map. >> >> To recreate: >> >> 1) Create a map containing PostGIS layers and save project to DB. All >> layers should be editable by the admin. Admin is logged into DB with auth >> config, not basic auth. >> 2) Create a new read-only user and new profile in QGIS and log in to DB. >> 3) Open the project and try to edit layers. Read-only user will be able >> to see and edit all layers just like the DB Admin. >> >> Is there a way to save projects to DB WITHOUT saving any user >> creds/permissions? >> >> Cliff >> >> -- >> >> Cliff Patterson Ph.D. >> >> *PSD* | Senior GIS Consultant >> P: 519-690-2565 ext. 2616 >> www.psdrcs.com >> London | 148 Fullarton St. 9th Floor >> >> > > -- > > Cliff Patterson Ph.D. > > *PSD* | Senior GIS Consultant > P: 519-690-2565 ext. 2616 > www.psdrcs.com > London | 148 Fullarton St. 9th Floor > > _______________________________________________ > Qgis-user mailing list > Qgis-user@lists.osgeo.org > List info: https://lists.osgeo.org/mailman/listinfo/qgis-user > Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
_______________________________________________ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
