Grails - schema configuration

Question

How can I configure Grails (in DataSource.groovy file) to use specific schema that a given username has access to, but it is not necessarily the default schema for that user.

Thanks

Answer 1

I found a way to do it. Simply, add

hibernate.default_schema = 'schemaName'

In DataSource.groovy