<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p>I'm not entirely sure I've titled this correctly. <br>
</p>
<p>I have a client that has about 20 people editing. There is a want
to reduce editing pain by introducing dropdown lists in the form
of widgets. <br>
</p>
<ul>
<li>20 users have 20 logins to the postgres/postgis database <br>
</li>
<li>20 users have 20 qgs files which need to be replaced<br>
</li>
</ul>
<p>My first thought to "fix" some of the headache was using the
Authentification manager. I would have everyone set that up and I
could build the qgs files and pass them along. They would open
them and be asked for a password. The Authentification manager
passes their credentials back to the database. It replaces the
authcfg in the project with theirs and life is good. <br>
</p>
<p>What I am finding is that my layers which have an Auth-id of
xxxxxxx never get replaced by the Auth-id of their machine of
yyyyyyyy - so every time they open my new qgs file they are
prompted for the password of the authcfg database and their
connection credentials. Which - maybe that's the way it works and
not the way I think (which is generally not the way the world
works). <br>
</p>
<p>example: <i>dbname='client_database' host=gis4 port 5432
sslmode=disable authcfg=<b>938s81lr</b> key='id' srid=2274
type=multilinestring table="fiber.m_fiber" (geom) sql=</i></p>
<p><i>Their authcfg is not</i><b><i> 938s81lr. </i></b><i>It never
gets replaced<b> </b>with their <b>authcfg</b></i><b><i><br>
</i></b></p>
<p>Is there a way to replace authcfg with their authcfg which would
let me cascade these new QGIS files to the users? I could
eliminate three things that must be typed down to one upon opening
the file. <br>
</p>
<p>Thanks much! Hopefully this all makes some sense. <br>
</p>
<p>Randy<br>
</p>
<p><br>
</p>
<p><br>
</p>
<p><br>
</p>
<pre class="moz-signature" cols="72">--
Randal Hale
<a class="moz-txt-link-abbreviated" href="mailto:rjhale@northrivergeographic.com">rjhale@northrivergeographic.com</a>
<a class="moz-txt-link-freetext" href="https://www.northrivergeographic.com">https://www.northrivergeographic.com</a>
(423)653-3611
</pre>
</body>
</html>