Security Guide : 5. Controlling Access through Database Procedures
 
Share this page                  
Controlling Access through Database Procedures
 
Database Procedures
Working with Procedure Objects
How to Implement a Database Procedure
Access Control 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.