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

Column Permission Discovery In Error

Nij4t2Nij4t2 Posts: 10
edited September 5, 2014 3:15AM in SQL Compare Previous Versions
I have a table where a column has been moved. This table has had an UPDATE permission granted to a role on a specific column.

For the purposes of this post, imagine that the source database table has column order A,B,C,D,E and the target database table has column order A,C,D,E,B. The update permission is on column 'B'

When I compare two versions of the database, SQL Compare tells me that the target database has the update permission on column B, but in fact the update permission is on column name E, and I can check that in both databases.


Interestingly, I just did another comparison on the same table to a slightly different database, and the column order was also different in this other db, but the column-permission comparison was not a problem; so there seems to be some variation in how this comparison works.
Sign In or Register to comment.