Re: Cannot see tables with ODBC

Hi James,

first of all it is a very bad idea to use the sys schema for user data. The sys schema contains all dictionary data and therefor it is a big security risk to allow users to connect as sys. Second issue is that the sys user writes by default into the system tablespace and therefor the performance of the whole database can decrease seriously. In case I remember right - just it is a very blurred memory - it is a security setting for the odbc connections not to show dictionary or sys objects. Please check the Mircosoft Knowledge Base for infos about a table, which can be created within Oracle to manage ODBC's general behavior at a single point.

Cheers,
Michael Received on Fri Sep 23 2005 - 03:05:25 CDT