I am relatively new to SQL Server 2005 and inherited it as configured. What I want to do is improve reporting capabilties to users through a tool they are familiar with, Excel 2003. As admin, this is not a problem and I can report
on all the tables. For a user, I want to restrict which tables a user has access to. Not sure how. I have read some documentation, security best practices and lots of Googling.
The SQL Server is configured with a number of databases with each having lots of tables. The one database I need to use has the tables the user needs but also a lot of tables he should not be accessing. They all share the same schema. I
want to restrict the tables he can see when importing the data into Excel. Not sure how and am hoping someone can provide some constructive suggestions, whether it can be done at all, or guidance as to where I can find the answer.
I've also thought of using a view but am not sure nor can I find where I can it make it avaible through Excel.
Any advise will be much appreciated. I hope this makes sense.
View Complete Post