service broker permission

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

news.microsoft.com - 27 Jun 2006 16:02 GMT

Hi

I have a queue execute on dbo and calling a stored procedure to process some
data. the stored procedure calls a view that references a table on another
database on the same server. I am getting a denied error when the procedure
select from the view? if I login as sa and select from the view on
management studio, its ok? is there a premission setting that I have to
set?

thanks

Pauli

Reply to this Message

Remus Rusanu [MSFT] - 27 Jun 2006 16:17 GMT

Mark the database trustworthy, you are under an EXECUTE AS context:
http://msdn2.microsoft.com/en-us/library/ms188304.aspx
The issue is described in BOL here:
http://msdn2.microsoft.com/en-us/library/ms166102.aspx
For a solution that does not require turnin on the trustworthy bit, see this
blog article:
http://blogs.msdn.com/remusrusanu/archive/2006/03/07/545508.aspx

Signature

This posting is provided "AS IS" with no warranties, and confers no rights.

HTH,
~ Remus Rusanu

SQL Service Broker
http://msdn2.microsoft.com/en-us/library/ms166043(en-US,SQL.90).aspx

> Hi
>
[quoted text clipped - 8 lines]
>
> Pauli

Reply to this Message