DEP018

ALL option in GRANT/DENY/REVOKE statement is deprecated

The  ALL keyword is highly confusing as it doesn’t add all permissions. It is legacy code that hasn’t kept pace with new versions of SQL Server. Don’t use it!



Didn't find what you were looking for?