Post reply

column level permission

  • 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

  • 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]

  • 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]

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply