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?
 
plusone3055Commented:
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
Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.