Sql Server 2008 R2 Database and Table Permissions

I'm using SqlServer Management Studio.
I want to grant a user datawriter permissions to all the tables in a database.  I created the user in the database and gave them the role datawriter.  But when I look a the permissions for a table, the user isn't listed.  Is there another step required?
Thanks,
Brooks
gbnortonAsked:
Who is Participating?
 
plusone3055Connect With a Mentor Commented:
click logins --- that name  
rightclick that name ---- properties
then click user mapping
and click off the databses you want them to be a datawriter too :)
0
 
plusone3055Commented:
yes in user mapping you have to check off the databases
0
 
gbnortonAuthor Commented:
Under Database, Security, Users, myuser I have the role db_datawriter selected.  Where is the mapping at?
0
[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

 
plusone3055Commented:
you have to right click the user name and slect properties
in the properties window  there is a selection on the far left that says User Mapping
0
 
plusone3055Commented:
I would send you a picture but that feature is currently disabled
I have provided the correct answer 1st...

heres complete steps

Create a user
right click him and select properties
under user mapping
check off a database and below check off data writer

keep repeating :)
0
 
plusone3055Commented:
also you need to right click the database and hit REFRESH then you will see that user listed :)
0
 
Scott PletcherSenior DBACommented:
>>  I created the user in the database and gave them the role datawriter. <<

From within that database, please double-check that you gave the user the db_datawriter role (bottom of screen) and not ownership of the db_datawriter schema (top of screen).


>> But when I look a the permissions for a table, the user isn't listed.  Is there another step required? <<

No.  Roles are not shown in the permissions list, only specific permission GRANTs, such as DELETE, INSERT, etc..
0
 
gbnortonAuthor Commented:
Thanks for your help.  In the end I fixed it by adding the role datareader.
0
All Courses

From novice to tech pro — start learning today.