Grails - schema configuration

How can I configure Grails (in DataSource.groovy file) to use specific sc开发者_开发知识库hema that a given username has access to, but it is not necessarily the default schema for that user.

Thanks

I found a way to do it. Simply, add

hibernate.default_schema = 'schemaName'

In DataSource.groovy

Unfortunetelly by DataSource.groovy you can't do that, because that information cannot be changed at runtime.