Is there anyway to disable the Allow Editing in MSQuery so as not to allow any data modifications to a SQL db. I have already done revoked all access in SQL. Yet, I can still modify in Excel using MSQuery and send it back to the SQL DB.
Originally posted by rnealejr
You can assign that user(s) the role of db_datareader for the database they are accessing. How are they connecting from excel to sql server - what type of authentification are you using ?
NT Authentication; I initially started with revoking db_datwriter then I went to db_datareader. I have not revoked public, yet. I am going to try it.