Post reply

Grant permission to only few tables in DB 2008

  • May 17, 2011 at 11:21 am

    #237627

    Hi,

    I need to give SELECT permission to only few tables and one view in a database to a SQL user. All other objects shouldn't have access.

    What is the best way of doing this? Sql server 2008.

    Thanks in advance

  • May 17, 2011 at 11:26 am

    #1326001

    Create a role and grant select on those tables and view to that role. Then add that user to the role.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

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

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