[infinispan-issues] [JBoss JIRA] (ISPN-3006) Oracle: TableManipulation.tableExists fails, when user has extended permissions

[Thomas Fromm (JIRA)]

    [ https://issues.jboss.org/browse/ISPN-3006?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12766530#comment-12766530 ] 

Thomas Fromm edited comment on ISPN-3006 at 4/11/13 11:30 AM:
--------------------------------------------------------------

Honestly I've not tested if using schema prefix within table name prefix already is recognized by the Metadata.getTables. Maybe it simply already works, so in this case I've only to prepend the user name on my side and there is no change required. Let me test it first...

Have tested it, getTables(null, null, "KOSCH.FOOBAR", new String[] {"TABLE"}) does not work.
So I'll change the impl as you said.
                
      was (Author: tfromm):
    Honestly I've not tested if using schema prefix within table name prefix already is recognized by the Metadata.getTables. Maybe it simply already works, so in this case I've only to prepend the user name on my side and there is no change required. Let me test it first...
                  
> Oracle: TableManipulation.tableExists fails, when user has extended permissions 
> --------------------------------------------------------------------------------
>
>                 Key: ISPN-3006
>                 URL: https://issues.jboss.org/browse/ISPN-3006
>             Project: Infinispan
>          Issue Type: Bug
>          Components: Loaders and Stores
>    Affects Versions: 5.3.0.Alpha1
>            Reporter: Thomas Fromm
>            Assignee: Mircea Markus
>            Priority: Minor
>
> 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.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira