Column Level Permission in SSC
Barry H
Posts: 10
Hi,
We are in the process of evaluating SQL Source control and have come across an issue.
When linking our databases to SSC with a TFS backend, it seems to have a problem with view that have column level permissions, when commiting the changes to SSC, everythign appear to be ok however, when you refresh the commit changes window, those views reappear as a change.
Has anyone else experience this and is there a fix/ work around for it?
Barry
We are in the process of evaluating SQL Source control and have come across an issue.
When linking our databases to SSC with a TFS backend, it seems to have a problem with view that have column level permissions, when commiting the changes to SSC, everythign appear to be ok however, when you refresh the commit changes window, those views reappear as a change.
Has anyone else experience this and is there a fix/ work around for it?
Barry
Comments
Column level permissions shouldn't cause any problems. Would you be able reply to the support ticket we've opened for you with the DDL for the problematic object?
Hopefully we can reproduce the problem and let you know what causing it.
This issue comes with column level permissions on a view. Code below
In the database it is:
When you select the commit changes window you see this
It seems to be ignoring the column permissions and granting select on the whole object.
Apologies for replying through the forum, I couldn't workout how to get to the support ticket
[/img]
I've reproduced this and it seems to be a bug.
The issue is being looked at by the developers and is logged as SC-5144.
Sorry you've encountered this, but thanks for letting us know.
It looks like it's currently scheduled for SQL Compare 10, which I would probably expect some time next year. We're still in the process of another 9.x release, so v10 doesn't have a release date yet.
The development team have had another look at this and decided to not make you wait until v10. There should be a fix for this is the next SQL Source Control EA release (current EA is 3.0.0.50).
You can get involved with the EA here
New SQL Compare v9.5 and SQL Source Control 3.0 Beta builds are now availble that should resolve this issue!
Download it from here:
http://www.red-gate.com/products/sql-development/sql-source-control/entrypage/migration
Redgate Software