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

Including permissions when creating change scripts in SQL Compare

Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
edited July 1, 2003 10:08AM in SQL Compare Previous Versions

Please make sure that the option 'Ignore object permissions' is not
selected. See next thread as well! :-)

Brian Donahue
Technical Support

"imarchenko" <imarchenko@hotmail.com> wrote in message
> Hello,
> I am a licensed user of SQL Compare bundle. I was wondering whether there
> a way to include permissions when generating change script in SQL Compare.
> If I view SQL of the stored procedure from two different SQL server I can
> see GRANT EXECUTE ON... statement. But this statement is missing when
> generating change script which makes them pretty much unusable since they
> are dropping and recreating objects meaning all permissions are lost.
> Thank you in advance,
> Igor.
This discussion has been closed.