Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
gamaz
Posting Yak Master
104 Posts |
 Posted - 2009-01-16 : 16:08:55
|
| Hi,I have created a sql server database and a new login named test. I would like to hide all tables and all views for this login test except for one view called salesanalysis. Is there a way to do that in sql server? Thanks. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-16 : 16:42:13
|
| Yes,Just give permission only to that view. |
 |
|
|
|
|
|
Denying visibility of all views and tables except