Good idea. On the trigger.  I'll give that a try.

Thanks
Justin

-----Original Message-----
From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Jeffrey Kain 
via 4D_Tech
Sent: Saturday, March 25, 2017 4:35 PM
To: 4D iNug Technical <4d_tech@lists.4d.com>
Cc: Jeffrey Kain <jeffrey.k...@gmail.com>
Subject: Re: Read Only 4D Server

Write a trigger that denies modifications and hook it into every table. Or 
allow your analytics only through SQL on the mirror and put that login into the 
read only schema. 

> On Mar 25, 2017, at 1:22 PM, Justin Will via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Does anyone know of a way to setup a Read-Only version of 4D server.  I am 
> considering setting up a mirror database for some analytic and reporting 
> functions and I only want to be able to integrate logs from a live server and 
> run some reports and queries against the read-only version of the system.
**********************************************************************
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**********************************************************************
**********************************************************************
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**********************************************************************

Reply via email to