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

Impersonate Permissions not being deloyed

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:

Comments

Sign In or Register to comment.