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.

Moderators: Chris Auckland, David Atkinson, sherr, PhilScrace

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: 1144
Joined: Wed Jun 16, 2010 11:10 am
Location: My desk.

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: 1144
Joined: Wed Jun 16, 2010 11:10 am
Location: My desk.


Return to SQL Source Control 2

Who is online

Users browsing this forum: No registered users and 0 guests