By default oracle names the schema same like the user that is connected. Well, when i use a different user to connect to BD, and existing objects in different schema's, objects like sequences or views, hibernate can not find them. I try to set all possible configuration in the mappings <class .. schema=""> and <param name="schema">name</>

I check the generated SQL and Hibernate trying to find SCHEMA_NAME.VIEW_NAME so, this is what it must ask, but the result is missing table or object in BD. I check several times, and the view or sequence exist, that for sure.
Can some body tell my if it is possible to work with database object pleased in a different schema that the default ??
I'm quite sure that this is the problem.

Hi smlghst,

Check the grant of your current schema

hello, i really need for help .. i now that the documentation seems like there is no problem acceding different schema's (with the DB permissions of
course ),and it work fine for Tables, but with sequences and views, Hibernate simply can not find. I don't now what was wrong, can some body tell my if it has been tested the scenario?
Bye

yes i restrict the permissions for Tables, and works fine, sequences only have two and are both set, and the user are able to select from views.
But the reality is that I'm not a well documented about permissions in the DB, can some body give me a trip?
Or it should not be a problem like it is ?
What permissions have to be set to use a different schema's in Hibernate?

I could not understand, Are you able to solve your problem

no . i only show the permissions in the BD, like it are, and it is not working.
So i ask if there is some permissions that have to be set to work with different schema's?
And I ask this, because i test it in the BD, and the user have the right permission.
So ..

Read ,write Grant