Security Guide > Security Guide > Controlling Access through Database Procedures
Was this helpful?
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.
Last modified date: 01/30/2023