DF013: The ALL option in the GRANT/DENY/REVOKE statement is deprecated.

Last modified: May 28, 2025

The topic describes the DF013 T-SQL code analysis rule.

Category

DEPRECATED

Message

The ALL option in the GRANT/DENY/REVOKE statement is deprecated.

Description

It is not recommended to use the GRANT, DENY, and REVOKE statements with the ALL option. This option is deprecated and maintained only for backward compatibility. It does not grant/deny/revoke all possible permissions.

Noncompliant code example

GRANT ALL ON dbo.Customers TO Mary
GO

Compliant solution

GRANT INSERT,UPDATE,DELETE ON dbo.Customers TO Mary
GO