<div>Hi Trevor,</div>
<div>I have seen this before but mostly with SQL Server databases (primarily because of client usage but I would expect the same behaviour) where when a user has select access to all tables/views in schema/database it has to walk through all.</div>
<div> </div>
<div>We were able to resolve it by creating specific users that had access to a very select group of tables/views which increased performance drastically (beware the 'public' user). We created the role and user and then granted specific privileges.</div>
<div> </div>
<div>In your case though, it appears that the problem is specific to public synonms so you'll have to revoke SELECT access from PUBLIC and then grant SELECT<br>access only to those that need to see the table.<br></div>
<div>Regards,</div>
<div>Jonathon<br><br></div>
<div class="gmail_quote">On Tue, Jun 29, 2010 at 7:09 PM, Trevor Wekel <span dir="ltr"><<a href="mailto:trevor_wekel@otxsystems.com">trevor_wekel@otxsystems.com</a>></span> wrote:<br>
<blockquote style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote">Hello,<br><br>I am posting this to -users since it may be of public interest. I have an Oracle 10g XE database with a single user and three attribute tables. There are no spatial tables in the database. When I create an ODBC database connection using Maestro or Autodesk MapGuide Studio 2011, the UI freezes for about five minutes.<br>
<br>Turning on trace logging reveals that the MapGuide Server is executing DescribeSchemaAsXML for the three tables owned by the user and all of the public synonyms visible to the user. This includes tables like ALL_CATALOG, CTX_OBJECTS, and WWV_FLOW_HOURS_12 just to name a few.<br>
<br>Does anyone have any suggestions on how to limit the schema walk to only return the tables owned by the Oracle user?<br><br>Thanks,<br><font color="#888888">Trevor<br></font><br>_______________________________________________<br>
mapguide-users mailing list<br><a href="mailto:mapguide-users@lists.osgeo.org">mapguide-users@lists.osgeo.org</a><br><a href="http://lists.osgeo.org/mailman/listinfo/mapguide-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapguide-users</a><br>
<br></blockquote></div><br>