Does not detect change relating to "GRANT REFERENCES"

wesleysmith

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?

James B

I'm not sure on this off the top of my head. I'll try replicating it here, and if it looks like it's not supported currently i'll raise a change request.

James B

OK, I see the same behaviour myself - I've logged it for our developers to take a look at, the reference is SOC-2344