Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Switching to generic user creates issue
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Maintenance bases de données
Versions des environnements
SQL Server:
SQL Server 2008
Application:
Desktop
Divers
Thread ID:
01563634
Message ID:
01563638
Vues:
48
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform