September 2010
Intermediate to advanced
1704 pages
111h 8m
English
An important task in endpoint management is the granting, revoking, and denying of endpoint permissions. To control whether a login may connect to (and thus consume) an endpoint, you use the following syntax:
![]()
For example, to give a login called MyDomain\MyUserName connect permission on your endpoint, you would use this statement:
![]()
Note that whenever the login specified in the AUTHORIZATION keyword of the endpoint DDL isn’t the same as the login consuming the service, you must grant connect permission to that login. ...