• For the new user, I'd it to generate a create user statement:

    USE [dbname]

    GO

    CREATE USER [mynewuser] FOR LOGIN [domain\firstname.lastname]

    GO

    Where mynewuser is paramater 1 and domain\firstname.lastname is second parameter.