DF013: The ALL option in the GRANT/DENY/REVOKE statement is deprecated.
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
Want to Find out More?
Overview
Take a quick tour to learn all about the key benefits delivered by dbForge Studio for SQL Server.
All features
Get acquainted with the rich features and capabilities of the Studio in less than 5 minutes.
Request a demo
If you consider employing the Studio for your business, request a demo to see it in action.
Ready to start using dbForge Studio for SQL Server?