954,560 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Have something to say? Contribute New Article Reply to this Article

Using multiple databases for one site, is it more secure?

I have a theory about the design of a new site I am working on. If a user accounts table is in one database, and the site content tables in another database, then it would be impossible for a hacker to use SQL injections in a form unrelated to the user database to get data from a table he should not have access to.

Is my thinking correct or incorrect?

ShadyTyrant
Junior Poster
127 posts since Nov 2009
Reputation Points: 10
Solved Threads: 19
 

In theory, this seems like it might work, but in practice, probably not, because once a cracker gets in to your database, it is likely that they will have more than enough information to get in to another one (i.e. once they have usernames and passwords, they can then enter your site and do another injection). Your best bet is to always sanitize input.

On a side note, this is a really cool idea about the best way to store information on a website.

- Joe

joehms22
Junior Poster
112 posts since Jan 2010
Reputation Points: 28
Solved Threads: 19
 

This article has been dead for over three months

Post: Markdown Syntax: Formatting Help
You
View similar articles that have also been tagged: