asked on

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

plusone3055

yes in user mapping you have to check off the databases

ASKER CERTIFIED SOLUTION

plusone3055

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

gbnorton

ASKER

Under Database, Security, Users, myuser I have the role db_datawriter selected. Where is the mapping at?

plusone3055

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

plusone3055

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 :)

plusone3055

also you need to right click the database and hit REFRESH then you will see that user listed :)

Scott Pletcher

>> 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..

gbnorton

ASKER

Thanks for your help. In the end I fixed it by adding the role datareader.