>> like rearranging deck chairs on the Titanic Lol, Hilarious analogy, is it really -THAT- bad having them on the same box? Thanks for the tips and link on the stored proc stuff, I'll give that a thorough run through this afternoon and see what I can get working.
I also like Gert Franz's concepts on where the details are stored. Thanks guys, Rob -----Original Message----- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: 14 June 2007 13:42 To: CF-Talk Subject: RE: Securing Datasources > Thanks for that mate, I know there are bigger security fish > to fry when working on the same box but unfortunately this > setup works better for my budget at the moment, give it 6 > months and I'll have grown out of it. Deciding whether to store passwords in the CF Administrator vs CFQUERY tags when you're running the database server on the same machine is like rearranging deck chairs on the Titanic. I just want you to be aware of that. > I've just created a user in the database with reader/writer > permissions and the datasource seems to test fine in the > admin panel, however, It doesn't seem to work with my stored > procs, I get a permissions error thrown by cf when running my > code, are there any additional rights I need to grant that user? You will have to explicitly grant permissions for stored procedures. You might find this useful: http://www.sqlservercentral.com/columnists/bkelley/sqlserversecuritythedb_ex ecutorrole.asp Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! This email has been processed by SmoothZap - www.smoothwall.net ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281124 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
