Please use pg_services. No Auth is stored. Just the service name. -+-+-+-+-+-+-+-+-+-Geomaster, LdaRua Afonso Palmeira, 31, 7 D4715-278 BragaNIF 510906109Tm +351 910333888Email [email protected] from my mobile. Please excuse the brevity, spelling and punctuation. -------- Mensagem original --------De : Cliff Patterson <[email protected]> Data: 29/05/20 18:39 (GMT+00:00) Para: qgis-user <[email protected]> Assunto: Re: [Qgis-user] Save projects to DB without creator's permissions 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? CliffOn Fri, May 29, 2020 at 1:29 PM Cliff Patterson <[email protected]> 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. 2616www.psdrcs.comLondon | 148 Fullarton St. 9th Floor -- Cliff Patterson Ph.D.PSD | Senior GIS Consultant P: 519-690-2565 ext. 2616www.psdrcs.comLondon | 148 Fullarton St. 9th Floor
_______________________________________________ Qgis-user mailing list [email protected] List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
