I need to use two different schemas: application data and shared enterprise data. Shared one must be used "read-only", and so database user has only grant select on it.
Is there any way I can use hbm2ddl.auto create or update during development? If I set it to 'update' it says:
Code:
INFO SchemaUpdate:138 - updating schema
(...) WARN JDBCExceptionReporter:77 - SQL Error: 1031, SQLState: 42000
(...) ERROR JDBCExceptionReporter:78 - ORA-01031: not enough privileges
(...) ERROR SchemaUpdate:165 - could not complete schema update
org.hibernate.exception.SQLGrammarException: could not get table metadata: COMU_LOCALIDAD
I'm using latest Hibernate 3.