0 Replies Latest reply on May 3, 2013 5:39 PM by 1007014

    ODBC Connection - System Tables

      I've setup an ODBC connection and it connects perfectly. The user account used for this connection has select only privileges to 5 tables. They use this ODBC connection in Excel using the data wizard.

      The problem I'm having is the list of tables available to the user includes many system tables from the CTXSYS, MDSYS, OLAPSYS, WMSYS, PUBLIC, WMSYS and XDB owners. I've tried revoking all priveleges from those schemas but they still show in the list? How do I filter the list to only tables which are owned by the user?