Saturday, June 09, 2007

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


Post a Comment

<< Home