Column Level Permission in SSC

• 
  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 Auckland September 05, 2011 13:21

  - 0 +
• 
  Hi,
  
  This issue comes with column level permissions on a view. Code below
  
  In the database it is:
  

  GRANT SELECT ([ColumnName]) ON [dbo].[vwViewName] TO [Role]
  

  
  When you select the commit changes window you see this
  
  

  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 September 07, 2011 04:14

  - 0 +
• 
  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 Auckland September 09, 2011 09:49

  - 0 +
• 
  Any updates on this? I'm having the same problem. Thx!

  chago2011 October 13, 2011 14:01

  - 0 +
• 

  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 Auckland October 14, 2011 04:20

  - 0 +
• 
  Is there a way to remove the pending change from the list under "Commit Changes"? It can be a little confusing.

  chago2011 October 14, 2011 06:51

  - 0 +
• 

  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 Auckland October 14, 2011 06:59

  - 0 +
• 
  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

  csmith October 28, 2011 05:29

  - 0 +

Add comment

Please sign in to leave a comment.