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 |
|
jbates99
Constraint Violating Yak Guru
396 Posts |
 Posted - 2009-09-27 : 19:13:33
|
| hi experts,One of the logins on this (2005) server has only 1 database role: db_datareader. Awhile back, I changed him from db_owner to db_datareader.**Recently we discovered that he can update a table.** I have re-confirmed that he has only the db_datareader role.The network admin assures me that that this user is not a member of any domain group that would have update permissions.Are there some other things I can check?Thanks, John |
|
|
|
|
|
Login Has db_datareader Only But User Can Update