-- Explicación del Script Combinado

SELECT 
    'CREATE USER [' + dp.name + '] FOR LOGIN [' + dp.name + '];' + CHAR(13) +
    STUFF((
        SELECT CHAR(13) + 'GRANT ' + p.permission_name + ' ON ' + 
            p.class_desc + '::[' + OBJECT_NAME(p.major_id) + '] TO [' + dp.name + '];'
        FROM sys.database_permissions p
        WHERE p.grantee_principal_id = dp.principal_id
        FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)')
    , 1, 1, '')
FROM
    sys.database_principals dp
WHERE
    dp.type_desc = 'SQL_USER'
GO