Permissions granted on dbo schema not compared

BobGoodBobGood Posts: 18 Bronze 3
edited April 2, 2009 7:19AM in SQL Compare Previous Versions
Permissions granted on the schema dbo are not compared.

We granted permissions in one database on the dbo schema as follows:

GRANT EXECUTE ON Schema::dbo TO ServiceAccountRole

We cannot locate the dbo Schema object to include in a comparison.

For that matter, we cannot locate the sys schema object either, but that is not an immediate concern.

Bob Good
Bob Good


  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    Hi Bob,

    I believe that this had been raised as bug SC-2800 and is fixed in SQL Compare version 8. You may go to the product page and download a free trial that you can run alongside your current version and see if that fixes the problem.

Sign In or Register to comment.