<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><div style="font-family: Calibri,sans-serif; font-size: 11pt;">Hi<br><br>Ask you DBA to create two users for you, one with ALL rights and one with read only rights.<br><br>MS SQL should have DML language section in its documentation that would be useful. Giving rights and roles to various users is an important function of any DB. I would recommend getting familiar with MSsql DML is vital for any project.<br><br>Good luck<br><br>Regards<br>Sarel</div></div><div dir="ltr"><hr><span style="font-family: Calibri,sans-serif; font-size: 11pt; font-weight: bold;">From: </span><span style="font-family: Calibri,sans-serif; font-size: 11pt;"><a href="mailto:johan@geosol.com.na">Johan van Rensburg</a></span><br><span style="font-family: Calibri,sans-serif; font-size: 11pt; font-weight: bold;">Sent: </span><span style="font-family: Calibri,sans-serif; font-size: 11pt;">2015-01-30 02:58 PM</span><br><span style="font-family: Calibri,sans-serif; font-size: 11pt; font-weight: bold;">To: </span><span style="font-family: Calibri,sans-serif; font-size: 11pt;"><a href="mailto:africa@lists.osgeo.org">Africa local chapter discussions</a></span><br><span style="font-family: Calibri,sans-serif; font-size: 11pt; font-weight: bold;">Subject: </span><span style="font-family: Calibri,sans-serif; font-size: 11pt;">Re: [OSGeo Africa] SQL Database</span><br><br></div>
<div class="WordSection1">
<p class="MsoNormal"><span style='color: rgb(31, 73, 125); font-family: "Calibri","sans-serif"; font-size: 11pt;'>Hi<o:p></o:p></span></p>
<p class="MsoNormal"><span style='color: rgb(31, 73, 125); font-family: "Calibri","sans-serif"; font-size: 11pt;'><o:p> </o:p></span></p>
<p class="MsoNormal"><span style='color: rgb(31, 73, 125); font-family: "Calibri","sans-serif"; font-size: 11pt;'>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='color: rgb(31, 73, 125); font-family: "Calibri","sans-serif"; font-size: 11pt;'><o:p> </o:p></span></p>
<div>
<p class="MsoNormal"><span lang="EN-US" style='color: rgb(54, 87, 140); font-family: "Arial","sans-serif"; font-size: 9pt;'>Best Regards</span><span lang="EN-US" style='color: rgb(31, 73, 125); font-family: "Arial","sans-serif"; font-size: 11pt;'><o:p></o:p></span></p>
<p class="MsoNormal"><b><span lang="EN-US" style='color: rgb(54, 87, 140); font-family: "Arial","sans-serif"; font-size: 9pt;'> </span></b><span lang="EN-US" style='color: rgb(31, 73, 125); font-family: "Arial","sans-serif"; font-size: 11pt;'><o:p></o:p></span></p>
<p class="MsoNormal"><b><span lang="EN-US" style='color: rgb(54, 87, 140); font-family: "Arial","sans-serif"; font-size: 9pt;'>Johan van Rensburg</span></b><span lang="EN-US" style='color: rgb(31, 73, 125); font-family: "Arial","sans-serif"; font-size: 11pt;'><o:p></o:p></span></p>
<div>
<div>
<div>
<div>
<p class="MsoNormal"><b><span lang="EN-US" style='color: rgb(135, 155, 186); font-family: "Arial","sans-serif"; font-size: 8pt;'>Professional GISc Practitioner PGP 0168<o:p></o:p></span></b></p>
<div>
<div>
<div>
<div class="MsoNormal"><span lang="EN-US" style="color: rgb(31, 73, 125);">
<hr width="100%" size="1" align="left" style="color: rgb(212, 217, 227);" noshade="">
</span></div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<p class="MsoNormal"><span lang="EN-US" style='color: rgb(54, 87, 140); font-family: "Arial","sans-serif"; font-size: 8pt;'>Geo Business Solutions</span><span lang="EN-US" style='color: rgb(135, 155, 186); font-family: "Arial","sans-serif"; font-size: 8pt;'>
</span><span lang="EN-US" style='color: silver; font-family: "Arial","sans-serif"; font-size: 8pt;'> </span><span lang="EN-US" style='color: silver; font-family: "Arial","sans-serif"; font-size: 5pt;'>l</span><span lang="EN-US" style='color: silver; font-family: "Arial","sans-serif"; font-size: 8pt;'> </span><span lang="EN-US" style='color: rgb(135, 155, 186); font-family: "Arial","sans-serif"; font-size: 8pt;'><a href="http://www.munsys.com/"><span style="color: rgb(135, 155, 186);">
</span></a></span><span lang="EN-US" style='color: rgb(54, 87, 140); font-family: "Arial","sans-serif"; font-size: 8pt;'><a href="http://www.geosol.com.na/">www.geosol.com.na</a> </span><span lang="EN-US" style='color: rgb(135, 155, 186); font-family: "Arial","sans-serif"; font-size: 8pt;'>
</span><span lang="EN-US" style='color: silver; font-family: "Arial","sans-serif"; font-size: 5pt;'>l</span><span lang="EN-US" style='color: silver; font-family: "Arial","sans-serif"; font-size: 8pt;'> Tel</span><span lang="EN-US" style='color: rgb(135, 155, 186); font-family: "Arial","sans-serif"; font-size: 8pt;'>: (061)
226929 </span><span lang="EN-US" style='color: silver; font-family: "Arial","sans-serif"; font-size: 8pt;'> </span><span lang="EN-US" style='color: silver; font-family: "Arial","sans-serif"; font-size: 5pt;'>l</span><span lang="EN-US" style='color: silver; font-family: "Arial","sans-serif"; font-size: 8pt;'> Fax</span><span lang="EN-US" style='color: rgb(135, 155, 186); font-family: "Arial","sans-serif"; font-size: 8pt;'>:
(061) 229623</span><span lang="EN-US" style='color: rgb(31, 73, 125); font-family: "Calibri","sans-serif"; font-size: 11pt;'><o:p></o:p></span></p>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div class="MsoNormal"><span lang="EN-US" style="color: rgb(31, 73, 125);">
<hr width="100%" size="1" align="left" style="color: rgb(212, 217, 227);" noshade="">
</span></div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<p class="MsoNormal"><span lang="EN-US" style='color: rgb(160, 160, 160); font-family: "Arial","sans-serif"; font-size: 8pt;'>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='color: rgb(31, 73, 125); font-family: "Calibri","sans-serif"; font-size: 11pt;'><o:p></o:p></span></p>
<div align="center" class="MsoNormal" style="text-align: center;"><span lang="EN-US" style="color: rgb(31, 73, 125);">
<hr width="100%" size="2" align="center">
</span></div>
<p class="MsoNormal"><b><i><span lang="EN-ZA" style="color: rgb(31, 73, 125); font-family: Webdings; font-size: 24pt;">P</span></i></b><b><span lang="EN-ZA" style='color: rgb(31, 73, 125); font-family: "Calibri","sans-serif"; font-size: 11pt;'>
</span></b><span lang="EN-ZA" style='color: rgb(31, 73, 125); font-family: "Calibri","sans-serif"; font-size: 11pt;'>P</span><span lang="EN-ZA" style='color: rgb(31, 73, 125); font-family: "Calibri","sans-serif"; font-size: 10pt;'>lease consider the environment before printing this
e-mail<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style='color: rgb(31, 73, 125); font-family: "Calibri","sans-serif"; font-size: 11pt;'><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style='color: rgb(31, 73, 125); font-family: "Calibri","sans-serif"; font-size: 11pt;'><o:p> </o:p></span></p>
<p class="MsoNormal"><span style='color: rgb(31, 73, 125); font-family: "Calibri","sans-serif"; font-size: 11pt;'> </span><span lang="EN-US" style='color: rgb(31, 73, 125); font-family: "Calibri","sans-serif"; font-size: 11pt;'><o:p></o:p></span></p>
</div>
<p class="MsoNormal"><span style='color: rgb(31, 73, 125); font-family: "Calibri","sans-serif"; font-size: 11pt;'><o:p> </o:p></span></p>
<div>
<div style="border-width: 1pt medium medium; border-style: solid none none; border-color: rgb(181, 196, 223) currentColor currentColor; padding: 3pt 0in 0in; border-image: none;">
<p class="MsoNormal"><b><span lang="EN-US" style='font-family: "Tahoma","sans-serif"; font-size: 10pt;'>From:</span></b><span lang="EN-US" style='font-family: "Tahoma","sans-serif"; font-size: 10pt;'> 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-family: "Calibri","sans-serif"; font-size: 11pt;'>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 align="center" class="MsoNormal" style="text-align: center;">
<hr width="100%" size="3" align="center">
</div>
<p class="MsoNormal" style="margin-bottom: 12pt;"><b><span style='font-family: "Calibri","sans-serif"; font-size: 11pt;'>From:
</span></b><span style='font-family: "Calibri","sans-serif"; font-size: 11pt;'><a href="mailto:johan@geosol.com.na">Johan van Rensburg</a></span><br>
<b><span style='font-family: "Calibri","sans-serif"; font-size: 11pt;'>Sent: </span>
</b><span style='font-family: "Calibri","sans-serif"; font-size: 11pt;'>2015-01-30 02:33 PM</span><br>
<b><span style='font-family: "Calibri","sans-serif"; font-size: 11pt;'>To: </span></b><span style='font-family: "Calibri","sans-serif"; font-size: 11pt;'><a href="mailto:africa@lists.osgeo.org">Africa local chapter discussions</a></span><br>
<b><span style='font-family: "Calibri","sans-serif"; font-size: 11pt;'>Subject: </span>
</b><span style='font-family: "Calibri","sans-serif"; font-size: 11pt;'>[OSGeo Africa] SQL Database</span><o:p></o:p></p>
</div>
<p class="MsoNormal"><span style='color: rgb(31, 73, 125); font-family: "Calibri","sans-serif"; font-size: 11pt;'>Dear All,<o:p></o:p></span></p>
<p class="MsoNormal"><span style='color: rgb(31, 73, 125); font-family: "Calibri","sans-serif"; font-size: 11pt;'><o:p> </o:p></span></p>
<p class="MsoNormal"><span style='color: rgb(31, 73, 125); font-family: "Calibri","sans-serif"; font-size: 11pt;'>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='color: rgb(31, 73, 125); font-family: "Calibri","sans-serif"; font-size: 11pt;'><o:p> </o:p></span></p>
<div>
<p class="MsoNormal"><span lang="EN-US" style='color: rgb(54, 87, 140); font-family: "Arial","sans-serif"; font-size: 9pt;'>Best Regards</span><span lang="EN-US" style='color: rgb(31, 73, 125); font-family: "Arial","sans-serif"; font-size: 11pt;'><o:p></o:p></span></p>
<p class="MsoNormal"><b><span lang="EN-US" style='color: rgb(54, 87, 140); font-family: "Arial","sans-serif"; font-size: 9pt;'> </span></b><span lang="EN-US" style='color: rgb(31, 73, 125); font-family: "Arial","sans-serif"; font-size: 11pt;'><o:p></o:p></span></p>
<p class="MsoNormal"><b><span lang="EN-US" style='color: rgb(54, 87, 140); font-family: "Arial","sans-serif"; font-size: 9pt;'>Johan van Rensburg</span></b><span lang="EN-US" style='color: rgb(31, 73, 125); font-family: "Arial","sans-serif"; font-size: 11pt;'><o:p></o:p></span></p>
<div>
<div>
<div>
<div>
<p class="MsoNormal"><b><span lang="EN-US" style='color: rgb(135, 155, 186); font-family: "Arial","sans-serif"; font-size: 8pt;'>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: rgb(31, 73, 125);">
<hr width="100%" size="1" align="left" style="color: rgb(212, 217, 227);" noshade="">
</span></div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<p class="MsoNormal"><span lang="EN-US" style='color: rgb(54, 87, 140); font-family: "Arial","sans-serif"; font-size: 8pt;'>Geo Business Solutions</span><span lang="EN-US" style='color: rgb(135, 155, 186); font-family: "Arial","sans-serif"; font-size: 8pt;'>
</span><span lang="EN-US" style='color: silver; font-family: "Arial","sans-serif"; font-size: 8pt;'> </span><span lang="EN-US" style='color: silver; font-family: "Arial","sans-serif"; font-size: 5pt;'>l</span><span lang="EN-US" style='color: silver; font-family: "Arial","sans-serif"; font-size: 8pt;'> </span><span lang="EN-US" style='color: rgb(135, 155, 186); font-family: "Arial","sans-serif"; font-size: 8pt;'><a href="http://www.munsys.com/"><span style="color: rgb(135, 155, 186);">
</span></a></span><span lang="EN-US" style='color: rgb(54, 87, 140); font-family: "Arial","sans-serif"; font-size: 8pt;'><a href="http://www.geosol.com.na/">www.geosol.com.na</a> </span><span lang="EN-US" style='color: rgb(135, 155, 186); font-family: "Arial","sans-serif"; font-size: 8pt;'>
</span><span lang="EN-US" style='color: silver; font-family: "Arial","sans-serif"; font-size: 5pt;'>l</span><span lang="EN-US" style='color: silver; font-family: "Arial","sans-serif"; font-size: 8pt;'> Tel</span></p></div></div><br><div>[The entire original message is not included.]</div></body></html>