No sync script actions to remove with grant option from role

Compares and synchronizes SQL Server databases, backups and scripts.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, eddie davis, Anu Deshpande, Michelle Taylor, alice.easey, james.billings, chengvoon.tong

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

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


Return to SQL Compare 10

Who is online

Users browsing this forum: No registered users and 0 guests