Column Level Permission in SSC

A SQL Server Management Studio add-in to source control your database in Subversion or Team Foundation Server.

Moderators: Chris Auckland, David Atkinson, sherr, PhilScrace

Column Level Permission in SSC

Postby Barry H » Thu Sep 01, 2011 3:45 pm

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
Barry H
 
Posts: 6
Joined: Wed Aug 31, 2011 1:47 pm

Postby Chris Auckland » Mon Sep 05, 2011 6:21 pm

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
Chris Auckland
 
Posts: 757
Joined: Tue Oct 24, 2006 2:12 pm
Location: Red Gate Software Ltd.

Postby Barry H » Wed Sep 07, 2011 9:14 am

Hi,

This issue comes with column level permissions on a view. Code below

In the database it is:

Code: Select all
 GRANT SELECT ([ColumnName]) ON [dbo].[vwViewName] TO [Role]


When you select the commit changes window you see this


Code: Select all
 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]
Barry H
 
Posts: 6
Joined: Wed Aug 31, 2011 1:47 pm

Postby Chris Auckland » Fri Sep 09, 2011 2:49 pm

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
Chris Auckland
 
Posts: 757
Joined: Tue Oct 24, 2006 2:12 pm
Location: Red Gate Software Ltd.

Postby chago2011 » Thu Oct 13, 2011 7:01 pm

Any updates on this? I'm having the same problem. Thx!
chago2011
 
Posts: 4
Joined: Thu Oct 13, 2011 6:53 pm
Location: Orlando, FL

Postby Chris Auckland » Fri Oct 14, 2011 9:20 am

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
Chris Auckland
 
Posts: 757
Joined: Tue Oct 24, 2006 2:12 pm
Location: Red Gate Software Ltd.

Postby chago2011 » Fri Oct 14, 2011 11:51 am

Is there a way to remove the pending change from the list under "Commit Changes"? It can be a little confusing.
chago2011
 
Posts: 4
Joined: Thu Oct 13, 2011 6:53 pm
Location: Orlando, FL

Postby Chris Auckland » Fri Oct 14, 2011 11:59 am

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
Chris Auckland
 
Posts: 757
Joined: Tue Oct 24, 2006 2:12 pm
Location: Red Gate Software Ltd.

Postby csmith » Fri Oct 28, 2011 10:29 am

Hi,

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
Chris Smith
Project Manager
Deployment Manager
csmith
 
Posts: 118
Joined: Thu Jun 30, 2011 2:15 pm
Location: Cambridge


Return to SQL Source Control 2

Who is online

Users browsing this forum: No registered users and 0 guests