daily pastebin goal
53%
SHARE
TWEET

Untitled

SQLSoldier Nov 9th, 2014 157 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
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top