SHARE
TWEET

Untitled

SQLSoldier Nov 9th, 2014 152 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Use master;
  2.  
  3. Create User TestNonSA Without login With default_schema = dbo;
  4. Go
  5.  
  6. Grant Create Procedure to TestNonSA;
  7. Grant Alter on schema::dbo to TestNonSA;
  8. Go
  9.  
  10. Execute As User = 'TestNonSA';
  11. Go
  12.  
  13. Create Procedure dbo.Test1
  14. As
  15. Select 1 As TestAnswer
  16. Go
  17.  
  18. Revert
  19. Go
  20.  
  21. Drop User TestNonSA;
  22. Drop Procedure dbo.Test1;
RAW Paste Data
Top