Click here to monitor SSC

C# SqlDependency.Start and permissions

Last post 06-08-2009, 10:57 AM by avitalit. 0 replies.
Sort Posts: Previous Next
  •  06-08-2009, 10:57 AM Post number 73702

    C# SqlDependency.Start and permissions

    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!!

     

View as RSS news feed in XML