Service Broker Routes
statementsService Broker Services
VIEW DEFINITION
CONTROL
VIEW DEFINITION
A Service Broker route is a database-level securable that is contained by the database that is its parent in the permissions hierarchy. The most specific and limited permissions that can be revoked on a Service Broker route are listed in the following table, together with the more general permissions that include them by implication.
CONTROL
CONTROL
CONTROL
TAKE OWNERSHIP
CONTROL
CONTROL
ALTER
CONTROL
ALTER ANY ROUTE
VIEW DEFINITION
CONTROL
VIEW DEFINITION
A Service Broker service is a database-level securable that is contained by the database that is its parent in the permissions hierarchy. The most specific and limited permissions that can be revoked on a Service Broker service are listed in the following table, together with the more general permissions that include them by implication.
CONTROL
CONTROL
CONTROL
TAKE OWNERSHIP
CONTROL
CONTROL
SEND
CONTROL
CONTROL
ALTER
CONTROL
ALTER ANY SERVICE
Service Broker service permission
Implied by Service Broker service permission
Implied by database permission