deny select on dbo.Shippers to User1;
用户[user1]禁止对表[shippers]进行修改
grant execute on dbo.usp_GetSortedShippers to user1;
用户[user1]可以执行usp_GetSortedShippers存储过程
deny select on dbo.Shippers to User1;
用户[user1]禁止对表[shippers]进行修改
grant execute on dbo.usp_GetSortedShippers to user1;
用户[user1]可以执行usp_GetSortedShippers存储过程