<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";
color:black;}
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";
color:black;}
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";
color:black;}
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;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle24
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle25
{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 bgcolor="white" 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 Gavin,<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">MS SQL Server 2012<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>
<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";color:windowtext">From:</span></b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif";color:windowtext">
<a href="mailto:africa-bounces@lists.osgeo.org">africa-bounces@lists.osgeo.org</a> [<a href="mailto:africa-bounces@lists.osgeo.org">mailto:africa-bounces@lists.osgeo.org</a>]
<b>On Behalf Of </b>Gavin Fleming<br>
<b>Sent:</b> Friday, January 30, 2015 3:08 PM<br>
<b>To:</b> <a href="mailto:africa@lists.osgeo.org">africa@lists.osgeo.org</a><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>
<p class="MsoNormal">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:<o:p></o:p></p>
</div>
<div>
<div>
<p class="MsoNormal" align="center" style="text-align:center">Kartoza = Linfiniti
<span style="font-family:"Cambria Math","serif"">∪</span> Afrispatial<o:p></o:p></p>
</div>
</div>
</div>
</body>
</html>