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

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

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Minor
    • 5.3.0.Beta1
    • 5.3.0.Alpha1
    • Loaders and Stores
    • None

    Description

      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.

      Attachments

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: