The syntax for restricting roles using set proxy in the reference pages for the grant command incorrectly describes the parameter as “restricted role.” If you execute grant set proxy with this syntax, you see the following error:
1> grant set proxy to tester restricted role all 2> go
Msg 102, Level 15, State 1: Server 't15', Line 1: Incorrect syntax near 'restricted'.
The correct syntax is “restrict role”:
grant set proxy to role_list [restrict role role_list | all | system]
The error also appears in examples 38, 39, and 40 of the grant command.
