SQL: Using Instead Of Update to allow updates by certain users

5 pts.
Tags:
SQL
I want to use an Instead Of Update to limit updates by Admins only. I have the code for the case when it is not an Admin doing the update but if the user is an Admin do I have to manually code the update for the table for every field from the inserted table?


Software/Hardware used:
SQL 2014
0

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • ToddN2000
    Please post your code so we can get a better understanding of what you are trying to do.
    131,380 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: