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

permissions on stored procedures not being compared

Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
edited November 9, 2005 7:45AM in SQL Compare Previous Versions
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
>
>

Comments

  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    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
    > >>
    > >>
    > >
    > >
    > >
    >
  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    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.
This discussion has been closed.