>>Hi all
>>
>>Keeping in mind that we have no DBA
>>
>>When I change userid from mine to the generic that I want to use, I run into the happy circumstance where table inserts/updates/etc do not happen. The procedure runs perfectly under my ID, but nothing happens (and no error generated) under the generic ID.
>>
>>The connection happens just fine. Just nothing else.
>>
>>What do y'all need to see to tell me what I'm missing?
>>
>>Thanks
>
>The generic userid does not have the proper rights, try assigning the roles sqlreader and sqlwriter to said user id
I've got datareader and datawriter assigned and I'm hoping those are just the new names for the same rights that were in SQL 2005
"You don't manage people. You manage things - people you lead" Adm. Grace Hopper
Pflugerville, between a Rock and a Weird Place