Can we create a new user that can access the database, but cannot access it via SQL Server Management Studio (SSMS)?
I need this to create a "safe" connection to the database through VBA of Office application, but in case the username and password is leaked, users still cannot connect through the SSMS. I made the user as data reader only, but for peace of mind, I want to make sure users cannot access it via SSMS, so that unwanted viewing of data may be prevented.
I'm using SQL Server 2008 R2. Please kindly help or share if there are other ways to do this.