Including permissions when creating change scripts in SQL Compare
Brian Donahue
Posts: 6,590 Bronze 1
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.
>
>
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.
