column level permission

• anil_kumar32

  Ten Centuries

  Points: 1378

  More actions

  July 5, 2011 at 10:38 pm

  #253219

  hi,

  how the permissions can be granted on some specific columns of a table?

  Regards,

  Anil kumar

• Maksymilian Mulawa

  Ten Centuries

  Points: 1336

  More actions

  July 6, 2011 at 12:54 am

  #1348762

  GRANT SELECT ON dbo.SampleTable(Column1) TO User1

  Cheers, Max

  Check-out free open-source utility Sql Server Replication Explorer[/url]

• anil_kumar32

  Ten Centuries

  Points: 1378

  More actions

  July 6, 2011 at 1:46 am

  #1348782

  [font="Times New Roman"]

  I was doing all that by creating a view on specific table columns then assigning permission on view.

  Thanks a bunch for your valuable suggestion.

  Best Regards,

  Anil Kumar

  Infosys

  [/font]