--Permisos de los Roles

SELECT 
    'CREATE ROLE [' + dbR.[name] + '];' + CHAR(13) +
    STUFF((
        SELECT CHAR(13) + 'GRANT ' + dp.permission_name + ' ON ' + 
            dp.class_desc + '::[' + OBJECT_NAME(dp.major_id) + '] TO [' + dbR.[name] + '];'
        FROM sys.database_permissions dp
        WHERE dp.grantee_principal_id = dbR.principal_id
        FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)')
    , 1, 1, '')
FROM	
    sys.database_principals AS dbR
WHERE 
    TYPE = 'R' AND is_fixed_role = 0
GO