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 |
|
ujjaval
Posting Yak Master
108 Posts |
 Posted - 2006-01-11 : 20:37:47
|
| Is it possible to put access restriction on one of the columns in Views?I think 'No' but just double want to double check.Thanks,Ujjaval. |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-01-11 : 21:20:36
|
| a view is supposed to provide restriction by defining which columns can be selected,remove the columns from the definition to restrict, otherwise use sproc and/or udf to select the allowable columnsHTH--------------------keeping it simple... |
 |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-01-11 : 21:35:47
|
You can grant permissions on columns in tables or views:grant select ( COL_1, COL_2, ... )on MyViewto MyRole, MyUser CODO ERGO SUM |
|
|
|
|
|
|
access restriction on View columns