Assembly | SqlServer.Rules.dll |
Namespace | SqlServer.Rules.Design |
Class | ProcedureContainsGrantRule |
Id | SRD0060 |
Friendly Name | Permission change in stored procedure |
Category | Design |
Ignorable | false |
Applicable Types | Procedure |
The procedure grants itself permissions. Possible missing GO command.
The procedure grants itself permissions. Possible missing GO command
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