January 5, 2018 at 2:07 am
Hi,
I was wondering if someone could help me find the missing permission.
We have a process which uses the Server Broker to update a web page showing the progress of a task.
When the account has db_owner on the db this works perfectly, however I dont want it to be an owner so I changed it to be a reader and writer, this caused issues as you would expect
with the Service Broker so then I granted the following (based on a bit of an internet search).
GRANT CREATE TABLE TO [Domain\User]
GRANT CREATE PROCEDURE TO [Domain\User]
GRANT CREATE SERVICE TO [Domain\User]
GRANT CREATE QUEUE TO [Domain\User]
GRANT SUBSCRIBE QUERY NOTIFICATIONS TO [Domain\User]
GRANT CONTROL ON SCHEMA::[dbo] TO [Domain\User]
GRANT IMPERSONATE ON USER::DBO TO [Domain\User]
The problem is that I'm getting the following error
Cannot find the procedure 'SqlQueryNotificationStoredProcedure-7b54671b-a1f2-405b-8c83-bdadd728f42c', because it does not exist or you do not have permission.
and
Cannot find the queue 'SqlQueryNotificationService-7b54671b-a1f2-405b-8c83-bdadd728f42c', because it does not exist or you do not have permission.
and to be honest I'm not sure why, is this a missing permission or do I need to do anything else?
Any help would be appreciated.
Thanks,
Nic
January 5, 2018 at 2:35 am
Hi,
Fixed it.
It was missing
GRANT RECEIVE ON QueryNotificationErrorsQueue TO [Domain\User]
I granted that it resolved the error.
Thanks to those who read the post. Hope this helps others down the line.
Nic
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply