revoke permission- syntax  clarrification.  (SQL 2012)

25112
25112 used Ask the Experts™
on
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?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Distinguished Expert 2017
Commented:
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

https://msdn.microsoft.com/en-us/library/ms187728.aspx
Senior DBA
Most Valuable Expert 2018
Top Expert 2014
Commented:
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