syntax problems with grant statement
dwsS3m
Posts: 2
This is an ongoing problem I've seen since sql compare 7, but when a GRANT VIEW DEFINITION ON [ class :: ] gets scripted by redgate, it leaves the delimited identifiers ([]'s) off of the securable.
This does not crop up during a comparison. In a comparison it will show the statement correctly as
GRANT VIEW DEFINITION ON USER:: [user with spaces] TO [myRole]
however, when it becomes a problem is when you try and make a syncrhoniztion file with SQL compare, the syntax then gets scripted incorrectly as
GRANT VIEW DEFINITION ON USER:: user with spaces TO [myRole]
which will obviously cause syntax errors when trying to build the database from the synchronization file.
any thoughts?
This does not crop up during a comparison. In a comparison it will show the statement correctly as
GRANT VIEW DEFINITION ON USER:: [user with spaces] TO [myRole]
however, when it becomes a problem is when you try and make a syncrhoniztion file with SQL compare, the syntax then gets scripted incorrectly as
GRANT VIEW DEFINITION ON USER:: user with spaces TO [myRole]
which will obviously cause syntax errors when trying to build the database from the synchronization file.
any thoughts?
Comments
This does appear to be a problem with SQL Compare 8.0, I could reproduce the issue with the steps you outlined - and I'm very suprised nobody has noticed this before.
I've now logged a bug report, so hopefully it will be fixed in the next version. For your reference, the bug tracking code for the issue is SC-4461.