aceess for service broker

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Roy Goldhammer - 11 Aug 2008 17:38 GMT

Hello there

I've build a simple procedure which send create new dialog if it not exist
and if so using current dialog.

when i run it as dbo i have no problem to read data from
conversation_endpoints. but when i read data from non dbo user it return no
results.

I tried with view, function or store procedure to bypass it but didn't
succeed. how can no dbo user can read endpoints so i can find the active
dialog?

Reply to this Message

Roger Wolter[MSFT] - 14 Aug 2008 00:38 GMT

You need VIEW DEFINITION permissions on the view to access these tables so
either grant this to your user or access then through a stored procedure
with RUN AS set to a user who has this permission.

Signature

This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

> Hello there
>
[quoted text clipped - 8 lines]
> succeed. how can no dbo user can read endpoints so i can find the active
> dialog?

Reply to this Message