T-SQL Analyzer

# SQL Server Rule: SRD0060 | | | |----|----| | Assembly | SqlServer.Rules | | 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 ```sql 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 ``` ### Remarks The rule checks for stored procedures, changing its own permissions. It is possible that a GO end of batch signaling command is missing and the statements in the script following the procedure are included in the procedure body. _{^{Generated by a tool}}