[OSGeo Africa] SQL Database

[Sarel]

Hi

Ask you DBA to create two users for you, one with ALL rights and one with read only rights.

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.

Good luck

Regards
Sarel

-----Original Message-----
From: "Johan van Rensburg" <johan at geosol.com.na>
Sent: ‎2015-‎01-‎30 02:58 PM
To: "Africa local chapter discussions" <africa at lists.osgeo.org>
Subject: Re: [OSGeo Africa] SQL Database

Hi
 
I have two types of users the ones that can edit the data and ones that cannot edit the SQL database
 
Best Regards
 
Johan van Rensburg
Professional GISc Practitioner PGP 0168



Geo Business Solutions    l  www.geosol.com.na  l Tel: (061) 226929    l Fax: (061) 229623



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. 



P Please consider the environment before printing this e-mail
 
 
 
 
From: africa-bounces at lists.osgeo.org [mailto:africa-bounces at lists.osgeo.org] On Behalf Of Sarel
Sent: Friday, January 30, 2015 2:56 PM
To: Africa local chapter discussions
Subject: Re: [OSGeo Africa] SQL Database
 
Hi

I general only give user read rights, thus should be done from the DB side.

Regards
Sarel



From: Johan van Rensburg
Sent: ‎2015-‎01-‎30 02:33 PM
To: Africa local chapter discussions
Subject: [OSGeo Africa] SQL Database
Dear All,
 
Can someone please advise how to set the opening of an SQL data layer as read only? In QGIS 2.2.0
 
Best Regards
 
Johan van Rensburg
Professional GISc Practitioner PGP 0168



Geo Business Solutions    l  www.geosol.com.na  l Tel<span lang="EN-US" style="font-size:8.0pt;font-family:"A

[The entire original message is not included.]
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/africa/attachments/20150130/8bf28da7/attachment.html>