Does not detect change relating to "GRANT REFERENCES"

A SQL Server Management Studio add-in to source control your database in Subversion or Team Foundation Server.

Does not detect change relating to "GRANT REFERENCES"

Postby wesleysmith » Mon Mar 14, 2011 9:18 pm

Using SQL Source Control 2.0.10.11:

I ran this command in SQL:

Code: Select all
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?
wesleysmith
 
Posts: 8
Joined: Thu Feb 25, 2010 5:23 am

Postby james.billings » Thu Mar 17, 2011 3:24 pm

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.billings
 
Posts: 1120
Joined: Wed Jun 16, 2010 11:10 am
Location: Red Gate

Postby james.billings » Thu Mar 17, 2011 4:12 pm

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.billings
 
Posts: 1120
Joined: Wed Jun 16, 2010 11:10 am
Location: Red Gate


Return to SQL Source Control Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests