>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
"The five senses obstruct or deform the apprehension of reality."
Jorge L. Borges?
"Premature optimization is the root of all evil in programming."
Donald Knuth, repeating C. A. R. Hoare
"To die for a religion is easier than to live it absolutely"
Jorge L. Borges