Impersonate Permissions not being deloyed

chris_godfreechris_godfree Posts: 50 Silver 1
in DLM Automation
Hi,

I've got a strange release error that I can't figure out the reason for. We have a User in source control with no permissions but the same user in our Test database has three impersonate permissions (which it should do, they were missing in source control). When I create a release, the removal of the impersonate permissions appears in the Changes list highlighted in red (as expected) but the SQL Script does not include the revoking of this permission (not expected) - there is another change being deployed which is scripted correctly.

I have checked the source control filter (it explicitly includes this user) and we have no additional SQL Compare options specified in the release definition. I've also done a direct comparison using SQL Compare which does script the revoke permissions correctly.

Any ideas for this discrepancy between the Change list and the SQL Script??

Chris
Tagged:
· Share on Twitter

Comments

Sign In or Register to comment.