Controlling Access through Database Procedures
Database Procedures
A database procedure is a set of SQL statements and control statements in a begin/end block that are stored as a unit in the database. It usually contains at least one query into the database, which is stored in compiled form with a Query Execution Plan.
A database procedure can have the Execute permission granted on it.
Database procedures provide the following security benefits:
• They provide an extra level of control over data access and modification.
• They can be used with security alarms to enhance the security-auditing features.