Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tommypa
Starting Member
19 Posts |
 Posted - 2008-10-01 : 10:22:55
|
| How do I setup my user to have write permissions? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-10-01 : 10:58:35
|
| Do you mean write permission in table or database,sp,functions,views? Can you elaborate clearly? |
 |
|
|
tommypa
Starting Member
19 Posts |
Posted - 2008-10-01 : 11:03:27
|
| I setup a new user in the db and need to make sure it has write permissions but am unsure which permissions or where to add them.I am sorry for the lack of details. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-10-01 : 11:10:37
|
| You mean for whole DB? Db_datawriter |
|
|
|
NeilG
Aged Yak Warrior
530 Posts |
Posted - 2008-10-01 : 11:26:55
|
| sp_addrolemember 'db_datawriter','userlogin' |
|
|
|
tommypa
Starting Member
19 Posts |
Posted - 2008-10-01 : 11:56:01
|
| Thank you! Where do I add these roles to that user? |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2008-10-01 : 12:21:43
|
| >> security >> login |
|
|
|
tommypa
Starting Member
19 Posts |
Posted - 2008-10-01 : 14:29:31
|
| I don't see that under security\loginI only have options like buladmindbcreatordiskadminprocessadminpublicsecurityadminserveradminsetupadmin and sysadminI dont see an area that has Db_datawriter |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-10-01 : 14:31:53
|
| Double click your login---user mapping--db_datawriter |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2008-10-01 : 17:08:12
|
| right click the user you want to assign a role to and click on user mapping as sodeep said. |
|
|
|
|
|
|
permissions