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 > > > > > > ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
