I haven't tried this, but I wonder if you could create a user that has 0 privileges. Maybe just give it read rights on tempdb, but nothing else. And then put that into your data source. So it's a valid user, but it can't access the sensitive databases.
On Fri, Nov 12, 2010 at 11:21 AM, Doug Ford <[email protected]> wrote: > > I am trying to add a level of security that if someone was able to access the > server and upload a file to read the SQL tables, I wanted to make sure that > without the proper password, a cfquery without a u/n & p/w, would fail in the > attempt. > > It's just all for security. > > >>Is there a reason why you don't want to put the correct UN/PW into the >>data source? >> >> >>> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339155 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
