What are the challenges you face when working across database platforms? Take the survey

Impersonate Permissions not being deloyed


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??



Sign In or Register to comment.