Red Gate forums :: View topic - Column Level Permission in SSC
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Source Control 2
SQL Source Control 2 forum

Column Level Permission in SSC

Search in SQL Source Control 2 forum
Post new topic   Reply to topic
Jump to:  
Author Message
Barry H



Joined: 31 Aug 2011
Posts: 6

PostPosted: Thu Sep 01, 2011 3:45 pm    Post subject: Column Level Permission in SSC Reply with quote

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
View user's profile Send private message
Chris Auckland



Joined: 24 Oct 2006
Posts: 755
Location: Red Gate Software Ltd.

PostPosted: Mon Sep 05, 2011 6:21 pm    Post subject: Reply with quote

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
View user's profile Send private message Send e-mail
Barry H



Joined: 31 Aug 2011
Posts: 6

PostPosted: Wed Sep 07, 2011 9:14 am    Post subject: Reply with quote

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
View user's profile Send private message
Chris Auckland



Joined: 24 Oct 2006
Posts: 755
Location: Red Gate Software Ltd.

PostPosted: Fri Sep 09, 2011 2:49 pm    Post subject: Reply with quote

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
View user's profile Send private message Send e-mail
chago2011



Joined: 13 Oct 2011
Posts: 4
Location: Orlando, FL

PostPosted: Thu Oct 13, 2011 7:01 pm    Post subject: Reply with quote

Any updates on this? I'm having the same problem. Thx!
Back to top
View user's profile Send private message
Chris Auckland



Joined: 24 Oct 2006
Posts: 755
Location: Red Gate Software Ltd.

PostPosted: Fri Oct 14, 2011 9:20 am    Post subject: Reply with quote

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
View user's profile Send private message Send e-mail
chago2011



Joined: 13 Oct 2011
Posts: 4
Location: Orlando, FL

PostPosted: Fri Oct 14, 2011 11:51 am    Post subject: Reply with quote

Is there a way to remove the pending change from the list under "Commit Changes"? It can be a little confusing.
Back to top
View user's profile Send private message
Chris Auckland



Joined: 24 Oct 2006
Posts: 755
Location: Red Gate Software Ltd.

PostPosted: Fri Oct 14, 2011 11:59 am    Post subject: Reply with quote

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
View user's profile Send private message Send e-mail
csmith



Joined: 30 Jun 2011
Posts: 114
Location: Cambridge

PostPosted: Fri Oct 28, 2011 10:29 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group