Does not detect change relating to "GRANT REFERENCES"

wesleysmithwesleysmith Posts: 12 Bronze 1
Using SQL Source Control 2.0.10.11:

I ran this command in SQL:
GRANT CREATE PROCEDURE to [sql_dependency_starter] 

GRANT CREATE QUEUE to [sql_dependency_starter]

GRANT REFERENCES on 
CONTRACT::[http://schemas.microsoft.com/SQL/Notifications/PostQueryNotification]
  to [sql_dependency_starter]

But when I look at what SQL Source Control scripts out for the "sql_dependency_starter" role, I see it scripting out "GRANT CREATE PROCEDURE", "GRANT CREATE QUEUE", etc. But it is missing the "GRANT REFERENCES ... " permission entirely.

Can you add support for this type of permission?

Comments

Sign In or Register to comment.