<html>
<head>
<meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">Hi Johan<br>
<br>
What database are you using? You'd set up permissions in the
database, in PostgreSQL like this:<br>
<br>
GRANT SELECT ON yourtable TO user;<br>
GRANT ALL ON yourtable TO editor;<br>
<br>
And ensure that the database connection each user connects with
contains the role name that matches their permissions. <br>
<br>
Gavin<br>
<br>
On 30/01/2015 14:58, Johan van Rensburg wrote:<br>
</div>
<blockquote
cite="mid:0FEB3B769844C74894D9B87956C07C2B5A260ED2@MBX246.domain.local"
type="cite">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<meta name="Generator" content="Microsoft Word 14 (filtered
medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]-->
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Webdings;
panose-1:5 3 1 2 1 5 9 6 7 3;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
pre
{mso-style-priority:99;
mso-style-link:"HTML Preformatted Char";
margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0in;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:Consolas;}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";}
span.EmailStyle21
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle22
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle23
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
<div class="WordSection1">
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">Hi<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">I
have two types of users the ones that can edit the data and
ones that cannot edit the SQL database<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<div>
<p class="MsoNormal"><span
style="font-size:9.0pt;font-family:"Arial","sans-serif";color:#36578C"
lang="EN-US">Best Regards</span><span
style="font-size:11.0pt;font-family:"Arial","sans-serif";color:#1F497D"
lang="EN-US"><o:p></o:p></span></p>
<p class="MsoNormal"><b><span
style="font-size:9.0pt;font-family:"Arial","sans-serif";color:#36578C"
lang="EN-US"> </span></b><span
style="font-size:11.0pt;font-family:"Arial","sans-serif";color:#1F497D"
lang="EN-US"><o:p></o:p></span></p>
<p class="MsoNormal"><b><span
style="font-size:9.0pt;font-family:"Arial","sans-serif";color:#36578C"
lang="EN-US">Johan van Rensburg</span></b><span
style="font-size:11.0pt;font-family:"Arial","sans-serif";color:#1F497D"
lang="EN-US"><o:p></o:p></span></p>
<div>
<div>
<div>
<div>
<p class="MsoNormal"><b><span
style="font-size:8.0pt;font-family:"Arial","sans-serif";color:#879BBA"
lang="EN-US">Professional GISc Practitioner PGP
0168<o:p></o:p></span></b></p>
<div>
<div>
<div>
<div class="MsoNormal"><span
style="color:#1F497D" lang="EN-US">
<hr style="color:#D4D9E3" align="left"
noshade="noshade" size="1" width="100%">
</span></div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<p class="MsoNormal"><span
style="font-size:8.0pt;font-family:"Arial","sans-serif";color:#36578C"
lang="EN-US">Geo Business Solutions</span><span
style="font-size:8.0pt;font-family:"Arial","sans-serif";color:#879BBA"
lang="EN-US">
</span><span
style="font-size:8.0pt;font-family:"Arial","sans-serif";color:silver"
lang="EN-US"> </span><span
style="font-size:5.0pt;font-family:"Arial","sans-serif";color:silver"
lang="EN-US">l</span><span
style="font-size:8.0pt;font-family:"Arial","sans-serif";color:silver"
lang="EN-US"> </span><span
style="font-size:8.0pt;font-family:"Arial","sans-serif";color:#879BBA"
lang="EN-US"><a moz-do-not-send="true"
href="http://www.munsys.com/"><span
style="color:#879BBA">
</span></a></span><span
style="font-size:8.0pt;font-family:"Arial","sans-serif";color:#36578C"
lang="EN-US"><a moz-do-not-send="true"
href="http://www.geosol.com.na/">www.geosol.com.na</a> </span><span
style="font-size:8.0pt;font-family:"Arial","sans-serif";color:#879BBA"
lang="EN-US">
</span><span
style="font-size:5.0pt;font-family:"Arial","sans-serif";color:silver"
lang="EN-US">l</span><span
style="font-size:8.0pt;font-family:"Arial","sans-serif";color:silver"
lang="EN-US"> Tel</span><span
style="font-size:8.0pt;font-family:"Arial","sans-serif";color:#879BBA"
lang="EN-US">: (061) 226929 </span><span
style="font-size:8.0pt;font-family:"Arial","sans-serif";color:silver"
lang="EN-US"> </span><span
style="font-size:5.0pt;font-family:"Arial","sans-serif";color:silver"
lang="EN-US">l</span><span
style="font-size:8.0pt;font-family:"Arial","sans-serif";color:silver"
lang="EN-US"> Fax</span><span
style="font-size:8.0pt;font-family:"Arial","sans-serif";color:#879BBA"
lang="EN-US">: (061) 229623</span><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"
lang="EN-US"><o:p></o:p></span></p>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div class="MsoNormal"><span
style="color:#1F497D" lang="EN-US">
<hr style="color:#D4D9E3" align="left"
noshade="noshade" size="1" width="100%">
</span></div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<p class="MsoNormal"><span
style="font-size:8.0pt;font-family:"Arial","sans-serif";color:#A0A0A0"
lang="EN-US">DISCLAIMER: This e-mail must not be copied,
disclosed or used by any person other than the
addressee(s) named above. Geo Business Solutions does not
endorse or accept responsibility for any personal views
expressed in this e-mail.
</span><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"
lang="EN-US"><o:p></o:p></span></p>
<div class="MsoNormal" style="text-align:center"
align="center"><span style="color:#1F497D" lang="EN-US">
<hr align="center" size="2" width="100%">
</span></div>
<p class="MsoNormal"><b><i><span
style="font-size:24.0pt;font-family:Webdings;color:#1F497D"
lang="EN-ZA">P</span></i></b><b><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"
lang="EN-ZA">
</span></b><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"
lang="EN-ZA">P</span><span
style="font-size:10.0pt;font-family:"Calibri","sans-serif";color:#1F497D"
lang="EN-ZA">lease consider the environment before
printing this e-mail<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"
lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"
lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"> </span><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"
lang="EN-US"><o:p></o:p></span></p>
</div>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #B5C4DF
1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b><span
style="font-size:10.0pt;font-family:"Tahoma","sans-serif""
lang="EN-US">From:</span></b><span
style="font-size:10.0pt;font-family:"Tahoma","sans-serif""
lang="EN-US"> <a class="moz-txt-link-abbreviated" href="mailto:africa-bounces@lists.osgeo.org">africa-bounces@lists.osgeo.org</a>
[<a class="moz-txt-link-freetext" href="mailto:africa-bounces@lists.osgeo.org">mailto:africa-bounces@lists.osgeo.org</a>]
<b>On Behalf Of </b>Sarel<br>
<b>Sent:</b> Friday, January 30, 2015 2:56 PM<br>
<b>To:</b> Africa local chapter discussions<br>
<b>Subject:</b> Re: [OSGeo Africa] SQL Database<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif"">Hi<br>
<br>
I general only give user read rights, thus should be
done from the DB side.<br>
<br>
Regards<br>
Sarel<o:p></o:p></span></p>
</div>
</div>
<div>
<div class="MsoNormal" style="text-align:center"
align="center">
<hr align="center" size="3" width="100%">
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><b><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif"">From:
</span></b><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif""><a
moz-do-not-send="true" href="mailto:johan@geosol.com.na">Johan
van Rensburg</a></span><br>
<b><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif"">Sent:
</span>
</b><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif"">2015-01-30
02:33 PM</span><br>
<b><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif"">To:
</span></b><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif""><a
moz-do-not-send="true"
href="mailto:africa@lists.osgeo.org">Africa local
chapter discussions</a></span><br>
<b><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif"">Subject:
</span>
</b><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif"">[OSGeo
Africa] SQL Database</span><o:p></o:p></p>
</div>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">Dear
All,<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">Can
someone please advise how to set the opening of an SQL data
layer as read only? In QGIS 2.2.0<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<div>
<p class="MsoNormal"><span
style="font-size:9.0pt;font-family:"Arial","sans-serif";color:#36578C"
lang="EN-US">Best Regards</span><span
style="font-size:11.0pt;font-family:"Arial","sans-serif";color:#1F497D"
lang="EN-US"><o:p></o:p></span></p>
<p class="MsoNormal"><b><span
style="font-size:9.0pt;font-family:"Arial","sans-serif";color:#36578C"
lang="EN-US"> </span></b><span
style="font-size:11.0pt;font-family:"Arial","sans-serif";color:#1F497D"
lang="EN-US"><o:p></o:p></span></p>
<p class="MsoNormal"><b><span
style="font-size:9.0pt;font-family:"Arial","sans-serif";color:#36578C"
lang="EN-US">Johan van Rensburg</span></b><span
style="font-size:11.0pt;font-family:"Arial","sans-serif";color:#1F497D"
lang="EN-US"><o:p></o:p></span></p>
<div>
<div>
<div>
<div>
<p class="MsoNormal"><b><span
style="font-size:8.0pt;font-family:"Arial","sans-serif";color:#879BBA"
lang="EN-US">Professional GISc Practitioner PGP
0168<o:p></o:p></span></b></p>
<div>
<div>
<div>
<div>
<div class="MsoNormal"><span
style="color:#1F497D" lang="EN-US">
<hr style="color:#D4D9E3" align="left"
noshade="noshade" size="1" width="100%">
</span></div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<p class="MsoNormal"><span
style="font-size:8.0pt;font-family:"Arial","sans-serif";color:#36578C"
lang="EN-US">Geo Business Solutions</span><span
style="font-size:8.0pt;font-family:"Arial","sans-serif";color:#879BBA"
lang="EN-US">
</span><span
style="font-size:8.0pt;font-family:"Arial","sans-serif";color:silver"
lang="EN-US"> </span><span
style="font-size:5.0pt;font-family:"Arial","sans-serif";color:silver"
lang="EN-US">l</span><span
style="font-size:8.0pt;font-family:"Arial","sans-serif";color:silver"
lang="EN-US"> </span><span
style="font-size:8.0pt;font-family:"Arial","sans-serif";color:#879BBA"
lang="EN-US"><a moz-do-not-send="true"
href="http://www.munsys.com/"><span
style="color:#879BBA">
</span></a></span><span
style="font-size:8.0pt;font-family:"Arial","sans-serif";color:#36578C"
lang="EN-US"><a moz-do-not-send="true"
href="http://www.geosol.com.na/">www.geosol.com.na</a> </span><span
style="font-size:8.0pt;font-family:"Arial","sans-serif";color:#879BBA"
lang="EN-US">
</span><span
style="font-size:5.0pt;font-family:"Arial","sans-serif";color:silver"
lang="EN-US">l</span><span
style="font-size:8.0pt;font-family:"Arial","sans-serif";color:silver"
lang="EN-US"> Tel</span><span
style="font-size:8.0pt;font-family:"Arial","sans-serif";color:#879BBA"
lang="EN-US">: (061) 226929 </span><span
style="font-size:8.0pt;font-family:"Arial","sans-serif";color:silver"
lang="EN-US"> </span><span
style="font-size:5.0pt;font-family:"Arial","sans-serif";color:silver"
lang="EN-US">l</span><span
style="font-size:8.0pt;font-family:"Arial","sans-serif";color:silver"
lang="EN-US"> Fax</span><span
style="font-size:8.0pt;font-family:"Arial","sans-serif";color:#879BBA"
lang="EN-US">: (061) 229623</span><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"
lang="EN-US"><o:p></o:p></span></p>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div class="MsoNormal"><span
style="color:#1F497D" lang="EN-US">
<hr style="color:#D4D9E3" align="left"
noshade="noshade" size="1" width="100%">
</span></div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<p class="MsoNormal"><span
style="font-size:8.0pt;font-family:"Arial","sans-serif";color:#A0A0A0"
lang="EN-US">DISCLAIMER: This e-mail must not be copied,
disclosed or used by any person other than the
addressee(s) named above. Geo Business Solutions does not
endorse or accept responsibility for any personal views
expressed in this e-mail.
</span><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"
lang="EN-US"><o:p></o:p></span></p>
<div class="MsoNormal" style="text-align:center"
align="center"><span style="color:#1F497D" lang="EN-US">
<hr align="center" size="2" width="100%">
</span></div>
<p class="MsoNormal"><b><i><span
style="font-size:24.0pt;font-family:Webdings;color:#1F497D"
lang="EN-ZA">P</span></i></b><b><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"
lang="EN-ZA">
</span></b><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"
lang="EN-ZA">P</span><span
style="font-size:10.0pt;font-family:"Calibri","sans-serif";color:#1F497D"
lang="EN-ZA">lease consider the environment before
printing this e-mail<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"
lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"
lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"> </span><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"
lang="EN-US"><o:p></o:p></span></p>
</div>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span
style="font-size:9.0pt;font-family:"Arial","sans-serif";color:black"
lang="EN-US">~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
</span><span lang="EN-US"><o:p></o:p></span></p>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Africa mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Africa@lists.osgeo.org">Africa@lists.osgeo.org</a>
You can UNSUBSCRIBE at <a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/africa">http://lists.osgeo.org/mailman/listinfo/africa</a></pre>
</blockquote>
<br>
<br>
<div class="moz-signature">-- <br>
<div style="text-align:center">
------------------------------------------------------------------------------------------</div>
<div style="text-align:center"><img
src="cid:part7.03050800.08070700@kartoza.com" height="40"
width="200"></div>
<div style="text-align:center">Gavin Fleming PGP 1234</div>
<div style="text-align:center"><span style="text-align:start">Visit
</span><a href="http://kartoza.com/" style="text-align:start"
target="_blank">http://kartoza.com</a><span
style="text-align:start"> to find out about open source:</span><br
style="text-align:start">
<span style="text-align:start"> * Desktop GIS programming
services</span><br style="text-align:start">
<span style="text-align:start"> * Geospatial web development</span></div>
<div style="text-align:center"><span style="text-align:start">*
GIS Training</span></div>
<div style="text-align:center"><span style="text-align:start">*
Consulting Services</span></div>
<div style="text-align:center">
<div>Skype: phlemingo</div>
<div style="text-align:start">
<div style="text-align:center">-------------------------------------------------------------------------------------------</div>
<div style="text-align:center"><span style="text-align:start">Kartoza
= Linfiniti ∪ Afrispatial</span></div>
</div>
</div>
</div>
</body>
</html>