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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-08-06 : 08:53:12
|
| shine writes "Dear Sir, I just want to how to give column level permission in sql server 7eg --> I ahev tabel with 20 column in that 5 columns i have to make ready only permissionThese read only columns can not be edited my any of the userswhat will i do for thatwould u pls sent me a syntax for thisRegards,Shine" |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2002-08-06 : 08:59:38
|
I was wondering what a "Column Lever" was..  Create a view of the 5 columns and grant select on the view, instead of the table....Jay White{0} |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
|
|
|
|
|
Column lever permission in sql server7