This discussion is archived
0 Replies Latest reply: May 3, 2013 10:39 AM by 1007014 RSS

ODBC Connection - System Tables

1007014 Newbie
Currently Being Moderated
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?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points