Column Permission Discovery In Error
Nij4t2
Posts: 10
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.
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.
