Does not detect change relating to "GRANT REFERENCES"
wesleysmith
Posts: 12 Bronze 1
Using SQL Source Control 2.0.10.11:
I ran this command in SQL:
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?
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
Redgate Software
Redgate Software