Currently each client has their own database 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 client databases? I thought the best procedure is to give each client their own database. Create a account with access to only their database. In the CF admin datasource 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
