Controlling Access through Database Procedures¶

Database Procedures¶

A database procedureis 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 an extra level of control over data access and modification.