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.

 

I didnt know about the sql server.Its good that you shared with us.