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

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

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
news:JqtA23PPDHA.1416@server53...
> Hello,
>
> I am a licensed user of SQL Compare bundle. I was wondering whether there
is
> 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.