Hi, I am looking for a way to prevent a user from accessing our sql 2005 database through excel and word. Users have a login and password which give them full access to all tables in the database, but they go through a login script where permissions are granted/denied. They would avoid this limitation if connecting from anything other than the login program.
While the proper method may be modifying the users/logins themselves, I am looking for a quick fix, as the first method may take a while to go through all the users and determine what they need access to. I saw something about Logon scripts, but could use some additional guidance. Thank you for your help.