Red Gate forums :: View topic - No sync script actions to remove with grant option from role
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Compare 10
SQL Compare 10 forum

No sync script actions to remove with grant option from role

Search in SQL Compare 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message
crokusek



Joined: 20 Mar 2012
Posts: 3
Location: California

PostPosted: Thu Apr 18, 2013 1:14 am    Post subject: No sync script actions to remove with grant option from role Reply with quote

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.
Back to top
View user's profile Send private message
james.billings



Joined: 16 Jun 2010
Posts: 1121
Location: My desk.

PostPosted: Mon Apr 22, 2013 2:14 pm    Post subject: Reply with quote

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:
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?
Back to top
View user's profile Send private message
crokusek



Joined: 20 Mar 2012
Posts: 3
Location: California

PostPosted: Mon Apr 22, 2013 7:25 pm    Post subject: Reply with quote

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... )
Back to top
View user's profile Send private message
james.billings



Joined: 16 Jun 2010
Posts: 1121
Location: My desk.

PostPosted: Mon Apr 22, 2013 7:47 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group