October 23, 2015 at 4:09 am
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...
October 23, 2015 at 4:10 am
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
October 23, 2015 at 4:11 am
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
October 23, 2015 at 4:22 am
Thank you Gail Shaw and anthony for your quick response....
Regards
Chowdary...
November 4, 2015 at 11:28 am
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.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply