If your users have to login to the application using NTFS authorization, such as if you disable Anonymous access in IIS, then CF will have access to the user's network credentials and you could pass those into the query calls:
<cfquery name="getMyStuff" datasource="mySqlDatasource" username="#cgi.auth_user#" password="#cgi.auth_password#"> ... </cfquery> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325235 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
