| Author |
Message |
Barry H
Joined: 31 Aug 2011
Posts: 6
|
 Posted: Thu Sep 01, 2011 3:45 pm Post subject: Column Level Permission in SSC |
 |
|
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 |
|
| Back to top |
|
 |
Chris Auckland
Joined: 24 Oct 2006
Posts: 715
Location: Red Gate Software Ltd.
|
| Posted: Mon Sep 05, 2011 6:21 pm Post subject: |
|
|
Thanks for your post.
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.
_________________
Chris |
|
| Back to top |
|
|
Barry H
Joined: 31 Aug 2011
Posts: 6
|
| Posted: Wed Sep 07, 2011 9:14 am Post subject: |
|
|
Hi,
This issue comes with column level permissions on a view. Code below
In the database it is:
| Code: |
| GRANT SELECT ([ColumnName]) ON [dbo].[vwViewName] TO [Role] |
When you select the commit changes window you see this
| Code: |
| GRANT SELECT ON [dbo].[vwViewName] TO [Role] |
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] |
|
| Back to top |
|
|
Chris Auckland
Joined: 24 Oct 2006
Posts: 715
Location: Red Gate Software Ltd.
|
| Posted: Fri Sep 09, 2011 2:49 pm Post subject: |
|
|
Thanks for clarifying.
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.
_________________
Chris |
|
| Back to top |
|
|
chago2011
Joined: 13 Oct 2011
Posts: 4
Location: Orlando, FL
|
| Posted: Thu Oct 13, 2011 7:01 pm Post subject: |
|
|
| Any updates on this? I'm having the same problem. Thx! |
|
| Back to top |
|
|
Chris Auckland
Joined: 24 Oct 2006
Posts: 715
Location: Red Gate Software Ltd.
|
| Posted: Fri Oct 14, 2011 9:20 am Post subject: |
|
|
| Quote: |
| Any updates on this? I'm having the same problem. Thx! |
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.
_________________
Chris |
|
| Back to top |
|
|
chago2011
Joined: 13 Oct 2011
Posts: 4
Location: Orlando, FL
|
| Posted: Fri Oct 14, 2011 11:51 am Post subject: |
|
|
| Is there a way to remove the pending change from the list under "Commit Changes"? It can be a little confusing. |
|
| Back to top |
|
|
Chris Auckland
Joined: 24 Oct 2006
Posts: 715
Location: Red Gate Software Ltd.
|
| Posted: Fri Oct 14, 2011 11:59 am Post subject: |
|
|
| Quote: |
| 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
_________________
Chris |
|
| Back to top |
|
|
csmith
Joined: 30 Jun 2011
Posts: 86
Location: Cambridge
|
|
| Back to top |
|
|
|
