Guest User

Untitled

a guest
Jan 20th, 2018
87
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.17 KB | None | 0 0
  1. DENY UPDATE ON tableA TO userA;
  2.  
  3. EXECUTE AS USER = 'userA';
  4. GO
  5. update tableA set colA='0001' where id=1;
  6. GO
  7. REVERT;
  8.  
  9. update tableA set colA='0001' where id=1
Add Comment
Please, Sign In to add comment