At 03:21 PM 4/17/2002 -0400, you wrote: >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'm not quite sure I understand the full situation, but.. Does it matter if client1 accesses the data of client2? Based on what I am understanding, that it will be allowed. >I thought the best procedure is to give each client their own database. >Create a account with access to only their database. I would consider this a best practice. >In the CF admin datasource restrict sql operations to stored procedures >only. If you can do this, that would be great. Although many applications may require re-writes to allow for this, since many applications do not use stored procedures exclusively. -- Jeffry Houser | mailto:[EMAIL PROTECTED] Need a Web Developer? Contact me! AIM: Reboog711 | Fax / Phone: 860-223-7946 -- My Books: http://www.instantcoldfusion.com My Band: http://www.farcryfly.com ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
