Security benefits of stored Procedure ?
Rupali Shinde
When we write stored procedure on table, end user access only stored procedure at Data Layer. End user not able to access data layer directly instead intermediate layer is created named as Business layer.User Interact with business layer which in turn call Data Layer to get Database records.Provide Security on tables to prevent direct access to it.