Service Broker Remote Service Bindings

statements
#tsql#statements

VIEW DEFINITION

CONTROL

VIEW DEFINITION

A Service Broker message type 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 message type 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 MESSAGE TYPE

REFERENCES

CONTROL

REFERENCES

VIEW DEFINITION

CONTROL

VIEW DEFINITION

A Service Broker remote service binding 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 remote service binding 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 REMOTE

SERVICE BINDING

Expand table

Expand table

Service Broker remote service

binding permission

Implied by Service Broker remote

service binding permission

Implied by database

permission

Service Broker route

permission

Implied by Service Broker route

permission

Implied by database

permission

Service Broker service

permission

Implied by Service Broker service

permission

Implied by database

permission