I have a general application that have various applications inside it, so I made one module for each application (they share almost all layout properties and configurations).
But, my newest module wil have to access a specific schema (let's name it 'contracts').
This schema is just access by its owner (named 'contracts', too), so I can't (must not) connect my active records by my default connection (it uses another user that don't have access to my schema 'contracts').
I want to specify a specific connection to be used by my new module. I know that I can use DAO to make this, but I want to use Active Records. How can i do that?