I need to restrict people from using Excel to connect to other databases.
Situation: User have an Excel program that gets data from a specific database using Windows authentication. This is okay, however what if the user then tries to get data from a different database? Notice that the user does have permission to other databases that they should only access via .NET front ends.
I have looked into a trigger to catch information (note that MS BOL has error in function EVENTDATA example 3).
This gives me information about the application however I am not sure how best to implement it.
Thank you for your time.