Interesting, Jorge. Thanks Cliff
On Fri, May 29, 2020 at 2:35 PM Jorge Gustavo Rocha <[email protected]> wrote: > Please use pg_services. No Auth is stored. Just the service name. > > -+-+-+-+-+-+-+-+-+- > Geomaster, Lda > Rua Afonso Palmeira, 31, 7 D > 4715-278 Braga > NIF 510906109 > > Tm +351 910333888 <+351%20910333888> > Email [email protected] > > Sent 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? > > Cliff > > On 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. 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 > > -- 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 [email protected] List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
