As far as I know, SQL Server stored procedure is a way to implement these kind of security (access privilege) measures. However, once stored procedure is used, the data tables are not felt as data tables, students are forced to learn a new programming environment wrapped up by a set of stored procedures.
sql server performance
Linear Mode
