Using Stored Procedures in a Production Environment

When you use stored procedures in a production environment, it is important to keep track of how the stored procedures are being used. Some applications use a single user, or a small group of users, to access the database. Often this access is performed using stored procedures. When a stored procedure is rebuilt, you will need to ensure that the user is again granted the privileges to execute the procedures that they use.