<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<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]-->
</head>
<body lang="EN-GB" link="blue" vlink="purple">
<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 lang="EN-US" style="font-size:9.0pt;font-family:"Arial","sans-serif";color:#36578C">Best Regards</span><span lang="EN-US" style="font-size:11.0pt;font-family:"Arial","sans-serif";color:#1F497D"><o:p></o:p></span></p>
<p class="MsoNormal"><b><span lang="EN-US" style="font-size:9.0pt;font-family:"Arial","sans-serif";color:#36578C"> </span></b><span lang="EN-US" style="font-size:11.0pt;font-family:"Arial","sans-serif";color:#1F497D"><o:p></o:p></span></p>
<p class="MsoNormal"><b><span lang="EN-US" style="font-size:9.0pt;font-family:"Arial","sans-serif";color:#36578C">Johan van Rensburg</span></b><span lang="EN-US" style="font-size:11.0pt;font-family:"Arial","sans-serif";color:#1F497D"><o:p></o:p></span></p>
<div>
<div>
<div>
<div>
<p class="MsoNormal"><b><span lang="EN-US" style="font-size:8.0pt;font-family:"Arial","sans-serif";color:#879BBA">Professional GISc Practitioner PGP 0168<o:p></o:p></span></b></p>
<div>
<div>
<div>
<div class="MsoNormal"><span lang="EN-US" style="color:#1F497D">
<hr size="1" width="100%" noshade="" style="color:#D4D9E3" align="left">
</span></div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<p class="MsoNormal"><span lang="EN-US" style="font-size:8.0pt;font-family:"Arial","sans-serif";color:#36578C">Geo Business Solutions</span><span lang="EN-US" style="font-size:8.0pt;font-family:"Arial","sans-serif";color:#879BBA">
</span><span lang="EN-US" style="font-size:8.0pt;font-family:"Arial","sans-serif";color:silver"> </span><span lang="EN-US" style="font-size:5.0pt;font-family:"Arial","sans-serif";color:silver">l</span><span lang="EN-US" style="font-size:8.0pt;font-family:"Arial","sans-serif";color:silver"> </span><span lang="EN-US" style="font-size:8.0pt;font-family:"Arial","sans-serif";color:#879BBA"><a href="http://www.munsys.com/"><span style="color:#879BBA">
</span></a></span><span lang="EN-US" style="font-size:8.0pt;font-family:"Arial","sans-serif";color:#36578C"><a href="http://www.geosol.com.na/">www.geosol.com.na</a> </span><span lang="EN-US" style="font-size:8.0pt;font-family:"Arial","sans-serif";color:#879BBA">
</span><span lang="EN-US" style="font-size:5.0pt;font-family:"Arial","sans-serif";color:silver">l</span><span lang="EN-US" style="font-size:8.0pt;font-family:"Arial","sans-serif";color:silver"> Tel</span><span lang="EN-US" style="font-size:8.0pt;font-family:"Arial","sans-serif";color:#879BBA">: (061)
226929 </span><span lang="EN-US" style="font-size:8.0pt;font-family:"Arial","sans-serif";color:silver"> </span><span lang="EN-US" style="font-size:5.0pt;font-family:"Arial","sans-serif";color:silver">l</span><span lang="EN-US" style="font-size:8.0pt;font-family:"Arial","sans-serif";color:silver"> Fax</span><span lang="EN-US" style="font-size:8.0pt;font-family:"Arial","sans-serif";color:#879BBA">:
(061) 229623</span><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p></o:p></span></p>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div class="MsoNormal"><span lang="EN-US" style="color:#1F497D">
<hr size="1" width="100%" noshade="" style="color:#D4D9E3" align="left">
</span></div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<p class="MsoNormal"><span lang="EN-US" style="font-size:8.0pt;font-family:"Arial","sans-serif";color:#A0A0A0">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 lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p></o:p></span></p>
<div class="MsoNormal" align="center" style="text-align:center"><span lang="EN-US" style="color:#1F497D">
<hr size="2" width="100%" align="center">
</span></div>
<p class="MsoNormal"><b><i><span lang="EN-ZA" style="font-size:24.0pt;font-family:Webdings;color:#1F497D">P</span></i></b><b><span lang="EN-ZA" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">
</span></b><span lang="EN-ZA" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">P</span><span lang="EN-ZA" style="font-size:10.0pt;font-family:"Calibri","sans-serif";color:#1F497D">lease consider the environment before printing this
e-mail<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" 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"> </span><span lang="EN-US" 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: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 lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> africa-bounces@lists.osgeo.org [mailto:africa-bounces@lists.osgeo.org]
<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" align="center" style="text-align:center">
<hr size="3" width="100%" align="center">
</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 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 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 lang="EN-US" style="font-size:9.0pt;font-family:"Arial","sans-serif";color:#36578C">Best Regards</span><span lang="EN-US" style="font-size:11.0pt;font-family:"Arial","sans-serif";color:#1F497D"><o:p></o:p></span></p>
<p class="MsoNormal"><b><span lang="EN-US" style="font-size:9.0pt;font-family:"Arial","sans-serif";color:#36578C"> </span></b><span lang="EN-US" style="font-size:11.0pt;font-family:"Arial","sans-serif";color:#1F497D"><o:p></o:p></span></p>
<p class="MsoNormal"><b><span lang="EN-US" style="font-size:9.0pt;font-family:"Arial","sans-serif";color:#36578C">Johan van Rensburg</span></b><span lang="EN-US" style="font-size:11.0pt;font-family:"Arial","sans-serif";color:#1F497D"><o:p></o:p></span></p>
<div>
<div>
<div>
<div>
<p class="MsoNormal"><b><span lang="EN-US" style="font-size:8.0pt;font-family:"Arial","sans-serif";color:#879BBA">Professional GISc Practitioner PGP 0168<o:p></o:p></span></b></p>
<div>
<div>
<div>
<div>
<div class="MsoNormal"><span lang="EN-US" style="color:#1F497D">
<hr size="1" width="100%" noshade="" style="color:#D4D9E3" align="left">
</span></div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<p class="MsoNormal"><span lang="EN-US" style="font-size:8.0pt;font-family:"Arial","sans-serif";color:#36578C">Geo Business Solutions</span><span lang="EN-US" style="font-size:8.0pt;font-family:"Arial","sans-serif";color:#879BBA">
</span><span lang="EN-US" style="font-size:8.0pt;font-family:"Arial","sans-serif";color:silver"> </span><span lang="EN-US" style="font-size:5.0pt;font-family:"Arial","sans-serif";color:silver">l</span><span lang="EN-US" style="font-size:8.0pt;font-family:"Arial","sans-serif";color:silver"> </span><span lang="EN-US" style="font-size:8.0pt;font-family:"Arial","sans-serif";color:#879BBA"><a href="http://www.munsys.com/"><span style="color:#879BBA">
</span></a></span><span lang="EN-US" style="font-size:8.0pt;font-family:"Arial","sans-serif";color:#36578C"><a href="http://www.geosol.com.na/">www.geosol.com.na</a> </span><span lang="EN-US" style="font-size:8.0pt;font-family:"Arial","sans-serif";color:#879BBA">
</span><span lang="EN-US" style="font-size:5.0pt;font-family:"Arial","sans-serif";color:silver">l</span><span lang="EN-US" style="font-size:8.0pt;font-family:"Arial","sans-serif";color:silver"> Tel</span><span lang="EN-US" style="font-size:8.0pt;font-family:"Arial","sans-serif";color:#879BBA">: (061)
226929 </span><span lang="EN-US" style="font-size:8.0pt;font-family:"Arial","sans-serif";color:silver"> </span><span lang="EN-US" style="font-size:5.0pt;font-family:"Arial","sans-serif";color:silver">l</span><span lang="EN-US" style="font-size:8.0pt;font-family:"Arial","sans-serif";color:silver"> Fax</span><span lang="EN-US" style="font-size:8.0pt;font-family:"Arial","sans-serif";color:#879BBA">:
(061) 229623</span><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p></o:p></span></p>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div class="MsoNormal"><span lang="EN-US" style="color:#1F497D">
<hr size="1" width="100%" noshade="" style="color:#D4D9E3" align="left">
</span></div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<p class="MsoNormal"><span lang="EN-US" style="font-size:8.0pt;font-family:"Arial","sans-serif";color:#A0A0A0">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 lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p></o:p></span></p>
<div class="MsoNormal" align="center" style="text-align:center"><span lang="EN-US" style="color:#1F497D">
<hr size="2" width="100%" align="center">
</span></div>
<p class="MsoNormal"><b><i><span lang="EN-ZA" style="font-size:24.0pt;font-family:Webdings;color:#1F497D">P</span></i></b><b><span lang="EN-ZA" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">
</span></b><span lang="EN-ZA" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">P</span><span lang="EN-ZA" style="font-size:10.0pt;font-family:"Calibri","sans-serif";color:#1F497D">lease consider the environment before printing this
e-mail<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" 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"> </span><span lang="EN-US" 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:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:9.0pt;font-family:"Arial","sans-serif";color:black">~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
</span><span lang="EN-US"><o:p></o:p></span></p>
</div>
</body>
</html>