I am adding a link to one of the MSDN SQL Server Security forum discussion regarding application security (i.e. restricting access to database resources based on the application): Yet another question on Application security....

  

   Please feel free to post any additional questions or feedback either on the forum or on this space.

 

  Thanks a lot,

-Raul