We want to give a user access to one view in a specific database. We have limited the user's acess to database so that he can only select from view. However, When we set up an ODBC connection on the user's PC and then use MS Query from Excel to look a the data, we can see all views in the MASTER database as well as the view in the database that we want him to see. How can we stop this user from viewing the data (i.e select columns from the views) in the master database.
So how can I remove permissions from Master so that the user cannot look at data in the tables?