Koen Verbeeck (3/7/2014)
Carlo Romagnano (3/7/2014)
Koen Verbeeck (3/7/2014)
Nice question, but I believe "not connected as sysadmin" is an equally correct answer though.ps: no actual connections to a certain Grant who is always ranting? 😎
From BOL:
The grantor (or the principal specified with the AS option) must have either the permission itself with GRANT OPTION or a higher permission that implies the permission being granted. Members of the sysadmin fixed server role can grant any permission.
Nothing in the question implicates Grant has the permission itself (it's a very logical assumption that he has, but an assumption nonetheless).
+1
____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”