Advertisement
SQLSoldier

Untitled

Nov 9th, 2014
292
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.32 KB | None | 0 0
  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;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement