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 |
|
Kimi86
Yak Posting Veteran
79 Posts |
 Posted - 2013-03-12 : 11:17:11
|
| Posting this question bit differently.I have a view which is selecting rows from a table in a different database on same server. I'd like to grant select access to the view, but not direct access to the base table. The view has a where clause restricting the number of rows.Can I grant select to the view and not the base table?? |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
|
|
|
|
|
grant on view but hide actual table