revoke permission- syntax  clarrification.  (SQL 2012)

25112 used Ask the Experts™
is both of the below the same? they don't give error..

revoke <perm> FROM user1
revoke <perm> TO user1

grammatically(English), one of them has to be wrong, if logically speaking?
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Distinguished Expert 2017
In the question you are confusing aspects.

Both can be correct.
One deals with revoking grant rights identified to whom they are granted, user1, negating the grant directive.

The other is more uniform revoke write rights from user1

Context of the <permissions> will dictate the correct pronoun
Senior DBA
Most Valuable Expert 2018
Top Expert 2014
MS allows the use of "TO" in place of "FROM", even if it sounds odd when read out.  They are synonyms to each other in this command and both function the same way.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial