Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 422
  • Last Modified:

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
0
gbnorton
Asked:
gbnorton
  • 5
  • 2
1 Solution
 
plusone3055Commented:
yes in user mapping you have to check off the databases
0
 
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
 
gbnortonAuthor Commented:
Under Database, Security, Users, myuser I have the role db_datawriter selected.  Where is the mapping at?
0
Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

 
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

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 5
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now