Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Cannot see tables with ODBC

Re: Cannot see tables with ODBC

From: Michael <michael.lohmar_at_gmail.com>
Date: 23 Sep 2005 01:05:25 -0700
Message-ID: <1127462725.692190.37350@g14g2000cwa.googlegroups.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US