No sync script actions to remove with grant option from role

Forum for users of SQL Compare schema synchronization utility

No sync script actions to remove with grant option from role

Postby crokusek » Thu Apr 18, 2013 1:14 am

Just a note that when the "With grant option" is in the right pane, the deployment script does not perform any action and cannot sync.

LeftSide
GRANT DELETE TO [SomeRole]

RightSide
GRANT DELETE TO [SomeRole] WITH GRANT OPTION


Perhaps this is also an issue within SQL Server itself because for the case I was testing the grant option is not honored anyway.
crokusek
 
Posts: 3
Joined: Tue Mar 20, 2012 7:02 pm
Location: California

Postby james.billings » Mon Apr 22, 2013 2:14 pm

Thanks for your post.

I tried setting up a replication of this myself, and the output script contains the following (which I'm hoping is correct?)


Code: Select all
PRINT N'Altering permissions on [dbo].[WidgetPrices]'
GO
REVOKE GRANT OPTION FOR DELETE ON  [dbo].[WidgetPrices] TO [testrole] CASCADE
GO


What version of SQL Compare are you working with? Also, have you got the option selected to "Ignore permissions" by any chance?
james.billings
 
Posts: 1120
Joined: Wed Jun 16, 2010 11:10 am
Location: Red Gate

Postby crokusek » Mon Apr 22, 2013 7:25 pm

Its probably possible to replicate it more than one way. What if start just enter "left side" text for Database A and "right side" text for Database B as shown from the example? Those both appear to be legal grants. The way you listed may work as well but I'm not familiar with cascade.

I do not have Ignore Permissions or User's permissions and role memberships selected.

( I may not be able to help much more on this issue right now... )
crokusek
 
Posts: 3
Joined: Tue Mar 20, 2012 7:02 pm
Location: California

Postby james.billings » Mon Apr 22, 2013 7:47 pm

The with cascade bit is just how Compare scripted out the difference- the key point is that it *did* script it out though. If you're able to confirm the exact version you're running, and even better supply snapshots of the two DBs (from File > Create Snapshots) that would be great (send them to support@red-gate.com with F0072014 in the subject line) - but if you've not got time to investigate further right now, that's no problem.
james.billings
 
Posts: 1120
Joined: Wed Jun 16, 2010 11:10 am
Location: Red Gate


Return to SQL Compare Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests

cron