<html><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8"></head><body dir="auto"><div dir="auto">Please use pg_services. No Auth is stored. Just the service name. </div><div dir="auto"><br></div><div id="composer_signature" dir="auto"><meta http-equiv="Content-Type" content="text/html; charset=UTF-8"><div>-+-+-+-+-+-+-+-+-+-</div><div>Geomaster, Lda<br>Rua Afonso Palmeira, 31, 7 D<br><a href="tel:4715-278" original_font_attr="-1" original_line_height_attr="">4715-278</a> Braga<br>NIF <a href="tel:510906109" original_font_attr="-1" original_line_height_attr="">510906109</a><br><br>Tm <a href="tel:+351 910333888" original_font_attr="-1" original_line_height_attr="">+351 910333888</a><br>Email <a href="mailto:jgr@geomaster.pt" original_font_attr="-1" original_line_height_attr="">jgr@geomaster.pt</a></div><div><br></div>Sent from my mobile. Please excuse the brevity, spelling and punctuation. </div><div dir="auto"><br></div><div><br></div><div style="font-size:100%;color:#000000" dir="auto"><!-- originalMessage --><div>-------- Mensagem original --------</div><div>De : Cliff Patterson <cpatterson@psdrcs.com> </div><div>Data: 29/05/20 18:39 (GMT+00:00) </div><div>Para: qgis-user <qgis-user@lists.osgeo.org> </div><div>Assunto: Re: [Qgis-user] Save projects to DB without creator's permissions </div><div><br></div></div><div dir="ltr">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? <div><br></div><div>Cliff</div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Fri, May 29, 2020 at 1:29 PM Cliff Patterson <<a href="mailto:cpatterson@psdrcs.com">cpatterson@psdrcs.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr">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. <div><br></div><div>To recreate:</div><div><br></div><div>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. </div><div>2) Create a new read-only user and new profile in QGIS and log in to DB.</div><div>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. </div><div><br></div><div>Is there a way to save projects to DB WITHOUT saving any user creds/permissions? </div><div><br></div><div>Cliff<br><div><div><br></div>-- <br><div dir="ltr"><div dir="ltr"><div><div dir="ltr"><p style="margin-bottom:0.0001pt">Cliff Patterson Ph.D.<br><br><b>PSD</b> | Senior GIS Consultant <br>P: 519-690-2565 ext. 2616<br><a href="http://www.psdrcs.com" target="_blank">www.psdrcs.com</a><br>London | 148 Fullarton St. 9th Floor <span style="font-size:small"> </span><br></p><p style="font-size:12.8px;margin-bottom:0.0001pt"><span style="font-size:12.8px"><span style="font-size:9pt;line-height:12.84px;font-family:Verdana,sans-serif;color:rgb(0,112,192)"><img src="http://psdrcs.com/assets/email_signature.png" width="200" height="57" onmouseover="imageMousePointerUpdate(true)" onmouseout="imageMousePointerUpdate(false)"></span></span></p></div></div></div></div></div></div></div>
</blockquote></div><br clear="all"><div><br></div>-- <br><div dir="ltr" class="gmail_signature"><div dir="ltr"><div><div dir="ltr"><p style="margin-bottom:0.0001pt">Cliff Patterson Ph.D.<br><br><b>PSD</b> | Senior GIS Consultant <br>P: 519-690-2565 ext. 2616<br><a href="http://www.psdrcs.com" target="_blank">www.psdrcs.com</a><br>London | 148 Fullarton St. 9th Floor <span style="font-size:small"> </span><br></p><p style="font-size:12.8px;margin-bottom:0.0001pt"><span style="font-size:12.8px"><span style="font-size:9pt;line-height:12.84px;font-family:Verdana,sans-serif;color:rgb(0,112,192)"><img src="http://psdrcs.com/assets/email_signature.png" width="200" height="57" onmouseover="imageMousePointerUpdate(true)" onmouseout="imageMousePointerUpdate(false)"></span></span></p></div></div></div></div>
</body></html>