--Assigns the appropriate connect/execute/db_datareader/db_datawriter permissions for the sql user on the search string below
BEGIN TRAN

DECLARE @dbname VARCHAR(100)
DECLARE @dbuser VARCHAR(100)
DECLARE @dbpass VARCHAR(100)
SET @dbuser = 'domain\username'
SET @dbpass = 'password'

--These are disabled so you can use domain auth, re-enable them to use sql quth (creating a sql user, root level)
--EXECUTE('use [master];CREATE LOGIN [' + @dbuser + '] WITH PASSWORD = ''' + @dbpass + ''' CHECK_POLICY = OFF, CHECK_EXPIRATION = OFF;')
--EXECUTE('use [master];CREATE USER [' + @dbuser + ']')

DECLARE dbloop CURSOR LOCAL FAST_FORWARD FOR
    SELECT name as dbname FROM master..sysdatabases where name like '%YOUR_DB_STRING%'
OPEN dbloop
FETCH NEXT FROM dbloop INTO @dbname
WHILE @@FETCH_STATUS = 0 BEGIN
  --These are disabled so you can use domain auth, re-enable them to use sql quth (creating a sql user, db level)
	--EXECUTE('use [' + @dbname + '];CREATE LOGIN [' + @dbuser + '] WITH PASSWORD = ''' + @dbpass + ''', CHECK_EXPIRATION = OFF;')
	--EXECUTE('use [' + @dbname + '];CREATE USER [' + @dbuser + ']')
	EXECUTE('use [' + @dbname + '];exec sp_addrolemember db_datareader, ''' + @dbuser + '''')
	EXECUTE('use [' + @dbname + '];exec sp_addrolemember db_datawriter, ''' + @dbuser + '''')
	EXECUTE('use [' + @dbname + '];GRANT EXECUTE to [' + @dbuser + ']')
	EXECUTE('use [' + @dbname + '];GRANT CONNECT to [' + @dbuser + ']')
	EXECUTE('use [' + @dbname + '];ALTER USER [' + @dbuser + '] WITH Login = [' + @dbuser + ']')
	EXECUTE('use [' + @dbname + '];exec sp_changedbowner ''sa''')

	FETCH NEXT FROM dbloop INTO @dbname
END
CLOSE dbloop
DEALLOCATE dbloop

--ROLLBACK TRAN
COMMIT TRAN