Uploaded image for project: 'Infinispan'
  1. Infinispan
  2. ISPN-3006

Oracle: TableManipulation.tableExists fails, when user has extended permissions

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Minor Minor
    • 5.3.0.Final
    • 5.3.0.Final
    • Loaders and Stores
    • None

      When an Oracle user has e.g. permissions to visit other schemas, the metaData.getTables returns not only the table matadata of the schema of the current user. So if a table exists in another user it returns true.

      Solution: Since we anyway do not support explicit definition of schema name in configuration, we can use in case of oracle the current user name as schema pattern for getTables(..)
      Other databases has different structures, e.g. in mysql the schema param seems to be ignored. To avoid problems the chance should be limited to oracle at the moment.

            mircea.markus Mircea Markus (Inactive)
            tfromm_jira Thomas Fromm (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved: