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 <[email protected]> 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: [email protected] [mailto:[email protected]] On Behalf Of GordonL Sent: Thursday, August 02, 2012 11:19 AM To: [email protected] 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 [email protected] 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 [email protected] http://lists.osgeo.org/mailman/listinfo/mapguide-users _______________________________________________ mapguide-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapguide-users
