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 |
|
MorrisK
Yak Posting Veteran
83 Posts |
 Posted - 2007-09-11 : 17:37:33
|
| I have an MS Access front end that connects to a SQL Server 2000 database using a DAO connection string.The login and user is a member of public, db_datareader and db_datawriter roles but for some reason this user cannot update a table. They can read data without any problem.In Enterprise Manager I see the above listed roles (and these roles only) when I go to the database>Users, right-click the user and select properties.Also, if I view the properties of the db_datawriter role I see the user listed.I'm fairly certain that in other databases this is all that was needed by this user in order to edit data.Can someone confirm if membership in db_datawriter is all that is needed to update data? If this is correct, how to do I figure out what is prevent them from updating?Thanks in advance,Kevin |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2007-09-11 : 17:38:52
|
| is there an explicit deny on the user on the table?--------------------keeping it simple... |
 |
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2007-09-11 : 17:54:28
|
| or is the database in read-only mode? |
|
|
|
MorrisK
Yak Posting Veteran
83 Posts |
Posted - 2007-09-11 : 17:54:43
|
| Thanks for the quick response. There is no explicit deny on the table that I can find. In any case, I think I've solved the problem but if someone could offer an explanation of what might have happened I would appreciate it.To solve the problem I deleted the user from the database. Then added them back as a member of the same roles as before (public, db_datareader, and db_datawriter).I guess my question now is what things can happen to a database user that would cause a problem like this?Kevin |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2007-09-11 : 18:17:49
|
| orphaned users or explicit denies--------------------keeping it simple... |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-12 : 23:36:03
|
| If the db is restored from backup, you may need remap user with sp_change_users_login. |
|
|
|
|
|
|
db_datawriter member can't update