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 |
|
timmy90210
Starting Member
1 Post |
 Posted - 2004-11-03 : 12:45:29
|
| I have a developer group that need read access on tables and I need to hide a few columns in the tables. What is the best way to do this. The more detailed the answer the better...Thanks. |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2004-11-03 : 13:33:13
|
| The DENY command can do this. You can DENY SELECT permissions on the column(s) to those users that shouldn't see them.The sooner you look up "DENY" in Books Online, the better. |
 |
|
|
hgorijal
Constraint Violating Yak Guru
277 Posts |
Posted - 2004-11-04 : 01:51:55
|
| But that will evan cause a SELECT * FROM <table> to fail. An alternative is to create view with only the columns you want the users to access and grant them permission only to that view.Hemanth GorijalaExchange a Dollar, we still have ONE each._______Exchange an Idea, we both have TWO each. |
|
|
|
|
|
|
Restrict Column view