US President Barack Obama has praised the heroism of soldiers and civilians in their response to the deadly attack at a US army base in Texas.