Writing Stored Procedures for Microsoft SQL Server

Security Basics

There are really three ways to provide security for your applications:

• You can rely on SQL Server to provide security for your application. This method is one of the simplest and allows you to have a single place to manage the security.

• You can use stored procedures as a security mechanism. With this method, you can create stored procedures that perform all the modifications to the tables in your database. You then apply security to the stored procedures.

• You can use a special security model in which you specify an application security context. This forces all your users to use a specific application to access the data. No other application works.