6 Replies Latest reply on Jul 23, 2017 9:36 PM by cute u

    Unable to connect to oracle database when user having no access to sys.tables

    Kulbhushan Chaskar Expert

      Hi,

       

      I am unable to connect to oracle database when user having no access to sys.tables.

       

      Like sys.tables what all dependencies we need to resolve to connect to the database.

       

      trowing the error

      2017-06-12 12:11:24,194 WARN  [org.teiid.PLANNER.RESOLVER] (Worker23_async-teiid-threads39)  TEIID31070 Empty model;There are no tables, procedures or functions defined in this model TESTDSORACLE20170612121123911

      but I ensure that the user has the table access to it.

       

      Note: I am using teiid 9.1.3 admin api and wildfly 10.0.0

       

      Thanks,

      Kulbhushan Chaskar.