Multiple database sessions

Hi guys,

What I found is with rails application we can have only one session to database. And for all logged in users it queries to database using that session. I need to have different databse session for different users session (basically to support multiple databases at the same time). Please suggest me way to do this.