I have a queue whose activation I defined as below
ALTER QUEUE SomeInitiatorQueue
( STATUS = ON,
PROCEDURE_NAME = usp_SomeProc,
MAX_QUEUE_READERS = 30,
EXECUTE AS OWNER)
Now I am trying to access another database in usp_SomeProc as below
Select SomeColumn SomeOtherDb.dbo.SomeTable
Here I am getting this error "The server principal "sa" is not able to access the database "SomeOtherDb" under the current security context."
It never allows unless I grant all permissions on the database to all.
what is the solution?
View Complete Post