Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Column Security

Answered Column Security

  • Monday, December 03, 2012 10:07 PM
     
     
    Sign In to Vote
    0

    Hi, 

    Is there a way to hide a column being viewed for a particular user accessing a particular table ?  The idea is to restrict a user to even view column name from the table and should not be able to read/write or any other activity . 

    Please guide

    Thanks,

    EVA05

     

All Replies

  • Monday, December 03, 2012 10:36 PM
     
     Answered
    Sign In to Vote
    0

    The best is to set up views that does not have this column, and then grant this user access to the view, but not the table.

    You can deny SELECT on column level and you can deny VIEW DEFINITION on the table. However, when someone is trying sort this out two years from now, they will hate you.

    Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
    • Marked As Answer by eva05 Tuesday, December 04, 2012 8:08 PM
    •  
     
  • Monday, December 03, 2012 11:44 PM
     
     Answered
    Sign In to Vote
    0

    Creating a view is the only option unless you are willing to create a new table.

    grant access your user to this view.

    • Marked As Answer by eva05 Tuesday, December 04, 2012 8:08 PM
    •  
     
  • Tuesday, December 04, 2012 7:00 PM
     
     Answered
    Sign In to Vote
    0

    Hi,

    Now in your case making VIEW is a better solution to do .

    Ahsan Kabir Please remember to click Mark as Answer and Vote as Helpful on posts that help you. This can be beneficial to other community members reading the thread. http://www.aktechforum.blogspot.com/

    • Marked As Answer by eva05 Tuesday, December 04, 2012 8:08 PM
    •