Home Forums SQL Server 2008 SQL Server Newbies Grant Permission to a table with restriction to data RE: Grant Permission to a table with restriction to data

  • October 26, 2012 at 1:35 am

    #1553055

    I think we can create a view than we can

    assign permission to a particular user for that view

    GRANT SELECT ON view-name TO user-name

    GRANT VIEW DEFINITION ON view_name TO user-name