# Rails running different database interation by user?

**URL:** <https://www.ruby-forum.com/t/rails-running-different-database-interation-by-user/87942>\
**Category:** Rails\
**Created:** [March 7, 2007, 12:48am UTC](https://www.ruby-forum.com/t/rails-running-different-database-interation-by-user/87942 "2007-03-07T00:48:33Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![ntk](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/n/48db29/32.png) [@ntk](https://www.ruby-forum.com/u/ntk)\
**Post date:** [March 7, 2007, 12:48am UTC](https://www.ruby-forum.com/t/rails-running-different-database-interation-by-user/87942/1 "2007-03-07T00:48:33Z")

</div>

Dear sir,  
I am familiar how Ruby on Rails creates a  
\myapplication\config\database.yml file for each project.  
Is there a way that I could use a separate database for each user?  
Obviously, I’m attempting to create a web based appication that  
maintains separate and distinct databases for each user/group/project  
entity.  
I don’t mean to ramble on here, but in most web enabled applications the  
programmer creates a connection prior to making any SQL call. This isn’t  
the case with RonR, but in the same way, when a user logs in, could I  
amend the standard (applicationName\_production) connection?  
Thank you,  
David