Skip to content

SRD0060.md

Latest commit

 

History

History
40 lines (29 loc) · 870 Bytes

SRD0060.md

File metadata and controls

40 lines (29 loc) · 870 Bytes

SQL Server Rule: SRD0060
Assembly SqlServer.Rules.dll
Namespace SqlServer.Rules.Design
Class ProcedureContainsGrantRule

Rule Information
Id SRD0060
Friendly Name Permission change in stored procedure
Category Design
Ignorable false
Applicable Types Procedure

Description

The procedure grants itself permissions. Possible missing GO command.

Summary

The procedure grants itself permissions. Possible missing GO command

Examples

 CREATE PROCEDURE dbo.my_proc 
 AS
     SELECT some_columns, some_calc 
     FROM some_set
     WHERE 1=0
     /* GO; */ /* < you might want one of these */
     GRANT exec to some_one