Different connections by module

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?

There is discussion about using multiple schema http://www.yiiframew…3.html#msg11623

Thanks, Will!