Security Features of Stored Procedures in Microsoft SQL Server

Security features of stored procedures are available in Microsoft SQL Server. These are :

1. Provide more granular security control through stored procedures rather than complete control on underlying data in tables.
2. Grants users permissions to execute a stored procedure irrespective of the related tables.
3. Grant users permission to work with a stored procedure to access a restricted set of data yet no give them permissions to update or select underlying data.
4. Stored procedures can be granted execute permissions rather than setting permissions on data itself.

See Also