Usually it is to add an extra layer of security. However, if you are using in SPs then I would write the code directly to the SP as there is less of a chance changes in the table can cause issues with the SP that way. A view remembers items ordinal position and if you make a change to the table without running sp_recompile then it won't adjust with it. You can no real bennifit from doing a view of the whole table.