Table level read and write permissions?

  • Hi All,

    I want give the permissions for an User as below

    1.i want to give the read permissions on 3 tables and

    2.write permission on 3 other tables to the same user .

    Please give me some solution...

    Regards
    Chowdary...

  • Take a look at GRANT

    GRANT SELECT ON .... TO ....

    GRANT INSERT UPDATE DELETE ON .... TO ....

    Also take a look at ROLES in case you need to do this to more than one user

  • Read up on the GRANT command.

    https://msdn.microsoft.com/en-us/library/ms187965.aspx

    https://msdn.microsoft.com/en-us/library/ms188371.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • Thank you Gail Shaw and anthony for your quick response....

    Regards
    Chowdary...

  • Chowdary,

    Just a quick recommendation. Find a place to store a copy of what permissions you give what users. It's really hard to maintain column and table level permissions when new people come into the company or old people leave unless you've documented what was granted in the first place.

    The GUI doesn't show the granular stuff below database level. At least, not easily. So save the code off in a DBA only location or write up a word doc on share point, or keep a DBA only database that lists everything. Just remember to track it.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Viewing 5 posts - 1 through 4 (of 4 total)

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