Options
Permissions granted on dbo schema not compared
BobGood
Posts: 16 Bronze 3
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
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
Comments
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!