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
Was this page helpful?