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 |
|
NguyenL71
Posting Yak Master
228 Posts |
 Posted - 2008-08-01 : 11:20:55
|
| Hi,Is there a way to grant VIEWS ONLY on user-defined functions, user-defined data types, and views to users. I only want them to VIEWs nothing else because this is production box (SQL Server 2005). Thank you in advance. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-08-01 : 11:34:08
|
| You mean view only definition. |
 |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2008-08-01 : 11:49:18
|
| GRANT VIEW DEFINITION works on either a schema level, or the object level. |
|
|
|
|
|
|
Is there a way to grant VIEWS ONLY in SQL 2005.