[mapguide-users] MapGuide 2.2 ODBC schema walk on Oracle 10g

[Jonathon McIntyre]

Hi Trevor,
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.

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.

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
access only to those that need to see the table.
Regards,
Jonathon

On Tue, Jun 29, 2010 at 7:09 PM, Trevor Wekel
<trevor_wekel at otxsystems.com>wrote:

> Hello,
>
> 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.
>
> 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.
>
> Does anyone have any suggestions on how to limit the schema walk to only
> return the tables owned by the Oracle user?
>
> Thanks,
> Trevor
>
> _______________________________________________
> mapguide-users mailing list
> mapguide-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapguide-users/attachments/20100629/40dfb713/attachment.html