How can we help you today? How can we help you today?

Permissions granted on dbo schema not compared

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
BobGood
0

Comments

1 comment

Sort by
  • Brian Donahue
    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.

    Thanks!
    Brian Donahue
    0

Add comment

Please sign in to leave a comment.