Are there any performance issues associated with combined all clients into a single database?
Thanks, Dave Bosky -----Original Message----- From: Mark Warrick [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 3:09 PM To: SQL Subject: Re: sql database/design/security NO!! Definitely not. Why in the world would you combine all the separate clients into a single database. That's a really bad idea for a lot of reasons. Keep it the way it is. ---mark --- "Bosky, Dave" <[EMAIL PROTECTED]> wrote: > Currently each of our clients has their own database > for their website on > our sql box. > Our web manager is considering moving all clients to > a single database > called > clients and use a single login from Cold Fusion to > access their data. > Is this the best practice? How do the rest of you > guys handle setting up and > accessing client databases? > > I thought the best procedure is to give each client > their own database. > Create a account with access to only their database. > > Restrict sql operations to stored procedures only. > > Any input? > Dave > > > > > > ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
