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