Excessive changes
jstangroome
Posts: 26
I have changed the REFERENCES permission on a user defined type in one database and I am trying to sync that to another. In this minimal case, the only change required on target db is:
REVOKE REFERENCES ON TYPE::dbo.mytype TO public
GRANT REFERENCES ON TYPE::dbo.mytype TO MyUser
But the output from SQL Compare insists on dropping and recreating the type then granting permissions.
Highly referenced types become troublesome as SQL Compare will remove all references to the type before the changes, then recreate the references after the permission change.
Is there a side-effect I'm not aware of?
Thanks,
- Jason
REVOKE REFERENCES ON TYPE::dbo.mytype TO public
GRANT REFERENCES ON TYPE::dbo.mytype TO MyUser
But the output from SQL Compare insists on dropping and recreating the type then granting permissions.
Highly referenced types become troublesome as SQL Compare will remove all references to the type before the changes, then recreate the references after the permission change.
Is there a side-effect I'm not aware of?
Thanks,
- Jason
