Grails - schema configuration

Question

How to configure Grails (in the DataSource.groovy file) to use a specific scheme that a given username has access to, but this is not necessarily a standard scheme for that user.

thanks

Answer 1

I found a way to do this. Just add

hibernate.default_schema = 'schemaName'

In DataSource.groovy

Answer 2

Unfortunately, DataSource.groovy you cannot do this because this information cannot be changed at runtime.