Hi All.
Iam a begginer with serviceBroker/QueryNotifier .
I Call to the service from server application using the start command.
the application crash unless I grant the ApplicationUser a db_owner permission.
I already grant this user : select on relevant tables,CREATE PROC,CREATE QUEUE,CREATE SERVICE,RECEIVE,REFERENCES .SUBSCRIBE .etc
I already added sql_dependency_subsriber and added this user to role member
what am I doing wrong ?
thanks in advance!!