Skip to content

Instantly share code, notes, and snippets.

@cobysy
Last active September 12, 2019 00:48
Show Gist options
  • Save cobysy/343d0676470187012a3a4666b6709728 to your computer and use it in GitHub Desktop.
Save cobysy/343d0676470187012a3a4666b6709728 to your computer and use it in GitHub Desktop.
Minimum Database Permissions Required for SqlDependency
GRANT CREATE PROCEDURE TO [SqlUser];
GRANT CREATE SERVICE TO [SqlUser];
GRANT CREATE QUEUE TO [SqlUser];
GRANT REFERENCES ON CONTRACT::[http://schemas.microsoft.com/SQL/Notifications/PostQueryNotification] TO [SqlUser];
GRANT SUBSCRIBE QUERY NOTIFICATIONS TO [SqlUser];
GRANT CONTROL ON SCHEMA::[dbo] TO [SqlUser];
GRANT IMPERSONATE ON USER::DBO TO [SqlUser];
-- This acually works
-- https://social.msdn.microsoft.com/Forums/sqlserver/en-US/bd195da8-93b2-43c6-8f59-674f5fb9d618/cannot-find-the-queue-sqlquerynotificationserviceguid?forum=sqlservicebroker&prof=required
-- Never got this to work: http://www.codeproject.com/Articles/12862/Minimum-Database-Permissions-Required-for-SqlDepen
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment