Advertisement
Guest User

Untitled

a guest
May 24th, 2015
193
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.67 KB | None | 0 0
  1. SET NOCOUNT ON;
  2.  
  3. DECLARE @user_name SYSNAME
  4. , @login_name SYSNAME;
  5.  
  6. SELECT @user_name = '',
  7. @login_name = ''
  8.  
  9. SELECT '
  10. USE ' + QUOTENAME(NAME) + ';
  11. BEGIN TRY
  12. CREATE USER ' + QUOTENAME(@user_name)
  13. + ' FOR LOGIN ' + QUOTENAME(@login_name)
  14. + ' WITH DEFAULT_SCHEMA=[dbo];
  15. END TRY
  16. BEGIN CATCH
  17. /* User exists - do nothing */
  18. END CATCH
  19. EXEC sys.sp_addrolemember
  20. ''db_datareader'',
  21. ' + QUOTENAME(@user_name) + ';
  22.  
  23. EXEC sys.sp_addrolemember
  24. ''db_datawriter'',
  25. '
  26. + QUOTENAME(@user_name) + ';
  27. GO
  28. '
  29. FROM sys.databases
  30. WHERE database_id > 4
  31. AND state_desc = 'ONLINE'
  32. -- AND name LIKE '%...%'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement