deny login with Microsoft Access

• Xavier LAURENT

  SSC Rookie

  Points: 28

  More actions

  February 10, 2006 at 8:28 am

  #89417

  Hi,

  I would like to deny users to connect to my SQL Server database  with Microsoft Access.

  My users are connecting with trusted connection and I allow them to connect with query analyser. I just want to deny usage of Microsoft Access.

  How can I do ?

  Thanks

• Jo Pattyn

  SSC-Dedicated

  Points: 32473

  More actions

  February 10, 2006 at 11:12 am

  #620237

  *One way could be with setting permission based on an application role

  in query analyzer they will need

  to execute sp_setapprole on the connection

  *you have the

  APP_NAME ( )  function  that returns the application name for the current connection