Does not detect change relating to "GRANT REFERENCES"

Using SQL Source Control 2.0.10.11:

I ran this command in SQL:

GRANT CREATE PROCEDURE to &#91;sql_dependency_starter&#93; 

GRANT CREATE QUEUE to &#91;sql_dependency_starter&#93;

GRANT REFERENCES on 
CONTRACT::&#91;http://schemas.microsoft.com/SQL/Notifications/PostQueryNotification&#93;
  to &#91;sql_dependency_starter&#93;

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?

wesleysmith March 14, 2011 16:18

Comments

2 comments

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 March 17, 2011 10:24

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

James B March 17, 2011 11:12

0

Add comment

Please sign in to leave a comment.

How can we help you today?

Does not detect change relating to &quot;GRANT REFERENCES&quot;

Comments