Database

NickPace wrote:

until I'm confident that the changeover of codebases to MySQL are complete

Declare @Usr varchar(50),
    @SQL as varchar(5000)

Declare csrPV Cursor Fast_Forward For
    Select name
    From sysusers
    Where issqluser = 1
        and hasdbaccess = 1
        AND name NOT IN ('dbo','IBMSQLDBA')

OPEN csrPV 

FETCH NEXT FROM csrPV INTO @Usr

WHILE @@FETCH_STATUS = 0
BEGIN

    Set @SQL = 'DROP USER [' + @Usr + ']'
    Print @SQL
    exec (@SQL)

    Set @SQL = 'CREATE USER [' + @Usr + '] FOR LOGIN [' + @Usr + '] WITH DEFAULT_SCHEMA=[dbo]'
    print @SQL
    exec (@SQL)

    Set @sql = 'ALTER LOGIN [' + @Usr + '] ENABLE'
    exec (@SQL)

    EXEC sp_addrolemember N'db_owner', @Usr

    FETCH NEXT FROM csrPV INTO @Usr
END
CLOSE csrPV
DEALLOCATE csrPV