My Microsoft SQL database contains multiple stored procedures with access to these stored procedures secured by SQL Authenticated Login Accounts (i.e. Manager, User, Auditor).
I am setting two session variables, session.UserName and session.Password, to the SQL Authenticated Login account for the level the person is authenticated (i.e. Manager) . I then pass this information through the âcfstoredprocâ tag by username=Session.UserName and password=Session.Password. My question is when setting up an ODBC connection to this database, do I have to setup a separate odbc connection for each one (User, Manager, Auditor) and set the username and password in the ODBC connection to each of their user name and password (In my case causing me to have 3 ODBC connections)? Because it seems as though my current ODBC connection via the CF Administrator overwrites any of the cfstoredproc settings. In other words, if I were to create my DSN in ColdFusion with the sa username and password, then it doesnât matter what username and password the cfstoredproc passes in â it will run because it is using SA â the DSN account, to run it. Do you know of any documents available that explains how the ODBC connections and SQL Security tie together? Thank you in advance for all of your help. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-OT/message.cfm/messageid:632 Subscription: http://www.houseoffusion.com/groups/CF-OT/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.29
