[mapguide-users] using views

[Johnnie GIS]

I have found that creating users/roles in SQL and then limiting views to that can make enough difference to be workable. Of course some views are just too complex for MG to run effectively. 

Regards,
Jonathon McIntyre
i-Open Technologies
Twitter: @JohnnieGIS
www.i-opentech.com
(C) 778-549-8382

Sent from my iPhone, please excuse any typos.

On Aug 2, 2012, at 1:35 PM, Jonathan Rizzo <jrizzo at Langan.com> wrote:

I will give that a try, although it will require a significant amount of work on the database (and related processes) to work around the limitations of schema bound views.  If that's the best way, then I suppose it has to be.  Thanks!

Jon

-----Original Message-----
From: mapguide-users-bounces at lists.osgeo.org [mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of GordonL
Sent: Thursday, August 02, 2012 11:19 AM
To: mapguide-users at lists.osgeo.org
Subject: Re: [mapguide-users] using views

If you were using Oracle, I would suggest a "Materialized View", but SQL does not have this.

Try this site to see how SQL handles this:
http://blogs.msdn.com/b/ssma/archive/2011/06/20/migrating-oracle-materialized-view-to-sql-server.aspx




--
View this message in context: http://osgeo-org.1560.n6.nabble.com/using-views-tp4992728p4992731.html
Sent from the MapGuide Users mailing list archive at Nabble.com.
_______________________________________________
mapguide-users mailing list
mapguide-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-users
This electronic transmission may contain confidential, proprietary or privileged information. No confidentiality or privilege is intended to be waived or lost by erroneous transmission of this message. If you receive this message in error, please notify the sender immediately by return email and delete this message from your system. Disclosure, use, distribution or copying of this message, any attachments thereto or their contents is strictly prohibited.
_______________________________________________
mapguide-users mailing list
mapguide-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-users