Can see Service Broker queue with SQL Server Login

Question

I have an application that is reading a message from a Service Broker Queue.  When I use integrated security with an NT account it works fine.  When I use a SQL Server User through Management Studio I can select from the Queue however, when I use this same account through the web app with the SQL Server User, I cannot see the Queue.  Is there a grant that I must do to this account to get it to see the Service Broker Objects?

Gary

 

Answer 1

Service broker doesn't use any special security/access checks other than the normal SQL Server security/ access restrictions. If the queue is visible from the SSMS, but not from the Web app, it means that the Web app it connects with different settings/credentials than the SSMS.

Answer 2

Remus,

What specific permissions do I grant so that an app can SELECT * from a queue?

Thanks

Jeff