permissions on stored procedures not being compared

Brian Donahue

Hello,

Obviously this is not what SQL Compare should be doing. Even if the
program is set to ignore permissions, the script that you get when you
double-click the stored procedure should still show the GRANT statements,
even thought they're not being compared. Can you tell me what version of SQL
Compare you use?

Brian Donahue
Technical Support
Red Gate Software

"HVE" <eylenh@hotmail.com> wrote in message
news:LEgimw5yCHA.1456@server53...
> Hi,
>
> we just realized that permissions on stored procedures are not being
> compared. For tables the GRANT statements are there, but not for stored
> procedures.The option 'ignore object permissions' is NOT checked.
>
> Is there something I'm missing or is this by design?
>
> Hans
>
>

Brian Donahue

Hi,

I understand now. It was a dependency problem. Whenever there are
dependencies, you have to script the child objects and the parent objects at
the same time. I knew that this was true with foreign keys and stored
procedures...

Brian Donahue

Technical Support Engineer

Red Gate Software Ltd.

+44 870 1600 037

mailto:brian.donahue@red-gate.com



"hve" <eylenh@hotmail.com> wrote in message
news:P8xnsoDzCHA.1432@server53...
> Hi Brian
>
> just discovered that GRANT statements are only generated if you select
> the user and/or role on which there are permissions.
>
> As a workaround, we can select all users/roles just to be safe.
>
> Hans
>
> Brian Donahue (Red Gate) wrote:
> > Hello,
> >
> > Obviously this is not what SQL Compare should be doing. Even if the
> > program is set to ignore permissions, the script that you get when you
> > double-click the stored procedure should still show the GRANT
statements,
> > even thought they're not being compared. Can you tell me what version of
SQL
> > Compare you use?
> >
> > Brian Donahue
> > Technical Support
> > Red Gate Software
> >
> > "HVE" <eylenh@hotmail.com> wrote in message
> > news:LEgimw5yCHA.1456@server53...
> >
> >>Hi,
> >>
> >>we just realized that permissions on stored procedures are not being
> >>compared. For tables the GRANT statements are there, but not for stored
> >>procedures.The option 'ignore object permissions' is NOT checked.
> >>
> >>Is there something I'm missing or is this by design?
> >>
> >>Hans
> >>
> >>
> >
> >
> >
>

Brian Donahue

FYI -- In SQL Compare 3.x, a new dependency engine was introduced that is vastly more accurate than SQL Server's sysdepends table. As a result, we have not heard of a single case where the include dependent objects setting did not cause SQL Compare to also script dependent objects along with an object that you want to migrate.