Perform highly privileged activities in SQL Server

• Define the minimal permissions necessary to perform the action.
• Define a database role that contains those permissions.
• Assign a user to that role.
• Create a stored procedure with the EXECUTE AS clause that will perform those functions.

Best Practices Analyzer, Multi-Core Processors, and More by Nancy Michell